No announcements
-
5 VotesWho will be announced as the next Transact-SQL Guru? Read more about April 2019 competition!!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. ...
-
0 Votes
POSTING TIPS - Code, Images, Hyperlinks, Details
When you're posting a question - please search the forum first! If that fails, and you wish to include T-SQL, C#, or VB code in your post, see below. If you're asking for ...
-
0 Votes
aborting a set based query based on a value retrieved
Hi we run 2016 enterprise. I like the ability to select … into #temp table from … Especially with an ever changing list of fields. I like that sql formats the ...Proposed | 10 Replies | 2500 Views | Created by db042190 - Tuesday, April 16, 2019 5:00 PM | Last reply by johnqflorida - 2 hours 53 minutes ago -
0 Votes
Merge + insert into + table with Computed column Erroring
Hi, I have table like this and merge statement: ACT table has identity column and computed column DECLARE ...Unanswered | 1 Replies | 54 Views | Created by Spunny - 5 hours 52 minutes ago | Last reply by Erland Sommarskog - 5 hours 0 minutes ago -
0 Votes
Login Logout Report
Hi, can you please help me find a query or process to get a report with all sql server database login and logout report for past 1 week. I already tried Trace and event logs which ...Unanswered | 4 Replies | 2746 Views | Created by SS88 - Thursday, April 18, 2019 8:21 PM | Last reply by Av111 - 13 hours 4 minutes ago -
2 Votes
Need help with % work allocation
Hi Team, I need a help with the query to get % allocation of consumers to the users within a group. There are groups under the group ...Unanswered | 6 Replies | 2855 Views | Created by Eswararao C - Friday, April 19, 2019 10:43 AM | Last reply by Erland Sommarskog - 20 hours 56 minutes ago -
2 Votes
How can I move a database diagram to another schema?
Hello, "alter schema ... transfer ..." is good for moving tables, views, SP's etc. to another schema, but cannot be applied to a database diagram object. How can I achieve ...Answered | 6 Replies | 5935 Views | Created by K.Kuehne - Thursday, November 11, 2010 4:12 PM | Last reply by scott_morris-ga - Saturday, April 20, 2019 3:29 PM -
0 Votes
compensation report not updating since pay period end 4/15/19
my compensation report has not updated at all since 4/15/19. each day it shows no new information, no hours flagged from the previous day and does not show my training pay from 4/16/19. is this normal ...Proposed | 3 Replies | 945 Views | Created by user10290 - Friday, April 19, 2019 9:13 AM | Last reply by Erland Sommarskog - Saturday, April 20, 2019 9:35 AM -
0 Votes
Biztalk WCF-SQL send port
Hi, I am executing Map in Biz talk wcf-SQL send port to execute send port to get the response from stored procedure returns. I have logic in side the stored procedure to use ...Unanswered | 2 Replies | 2770 Views | Created by saibabu - Friday, April 19, 2019 5:33 PM | Last reply by saibabu - Saturday, April 20, 2019 12:06 AM -
0 Votes
Duplicating Row from table and subtable using cursor
I currently am trying to duplicate some rows in a table, that also has a child table (1 to 1 relationship) that will also have rows duplicated. If I only had 1 row of the parent ...Unanswered | 1 Replies | 2080 Views | Created by HockeyFan1 - Friday, April 19, 2019 6:36 PM | Last reply by Erland Sommarskog - Friday, April 19, 2019 9:00 PM -
1 Votes
Access Previous Row in SQL to Calculate Data in Current Row
I am trying to calculate/derive a column data in a table (EndingonHandNew) with data from previous row, but I am not getting expected results. I am using the LAG ...Answered | 8 Replies | 4805 Views | Created by JB_Minnesota - Wednesday, April 17, 2019 7:04 PM | Last reply by JB_Minnesota - Friday, April 19, 2019 6:48 PM -
0 Votes
exists with intersection surprisingly slow
Hi we run 2016 enterprise. We just put up a new db and seeded it with 1.4 billion rows. I ran the query you see below and was surprised at how long it was taking. In fact I ...Unanswered | 5 Replies | 1621 Views | Created by db042190 - Friday, March 29, 2019 11:38 AM | Last reply by db042190 - Friday, April 19, 2019 6:43 PM -
0 Votes
Powershell convertto-csv ~ How do you print headers only when no results returned from Invoke-Sqlcmd?
I have a PowerShell script that is running a SQL query and exporting the results to a CSV file. The problem is that when the query returns no results, the subsequent CSV file is blank. I would like it ...Proposed | 5 Replies | 3911 Views | Created by MichaeleneJ - Thursday, April 18, 2019 6:34 PM | Last reply by Jingyang Li - Friday, April 19, 2019 6:13 PM -
0 Votes
sql datetime difference between two columns decimal
= DATEADD(Day, DATEDIFF(Day, 0, GetDate()), -1) -- Yesterday AND ResolveDateAnswered | 3 Replies | 1591 Views | Created by jimbrown.ws - Friday, April 19, 2019 3:37 PM | Last reply by Wild.Bill - Friday, April 19, 2019 5:00 PM -
0 Votes
How to check why the table is not updating in SQL server ?
We have table which gets data by running stored procedures, batch files and dtsx packages, which is running fine. Now, we have moved the whole database along with tables, bat files ...Unanswered | 9 Replies | 1725 Views | Created by Surya411 - Friday, April 19, 2019 9:15 AM | Last reply by Erland Sommarskog - Friday, April 19, 2019 4:59 PM -
2 Votes
Need Help in getting query for work balance
Hi Team, I need a help with the query to get the work balance among users in a group. There are groups under the group there are users and users will be working ...Answered | 8 Replies | 2659 Views | Created by Eswararao C - Thursday, April 18, 2019 1:23 PM | Last reply by Eswararao C - Friday, April 19, 2019 10:20 AM -
0 Votes
Using OpenRowset with ApplicationIntent=READONLY
I have a client trying to use OpenRowset to run a stored procedure against a ReadOnly database. We can run the stored procedure successfully against the database using the EXECUTE command ...Unanswered | 6 Replies | 1658 Views | Created by Lanis Ossman - Tuesday, April 16, 2019 12:02 PM | Last reply by Will_Kong - Friday, April 19, 2019 8:53 AM -
0 Votes
t-sql 2012 order by with a partition
In the t-sql 2012 listed below there is a value that is determined in the Sped_Max column. There are times when the calculation of SUM(ISNULL(CONVERT(INT, C1023.value), ...Answered | 4 Replies | 1661 Views | Created by wendy elizabeth - Wednesday, April 17, 2019 8:38 PM | Last reply by Rachel_Wang - Friday, April 19, 2019 7:46 AM -
0 Votes
Parent Child - TSQL review
Hi I'm trying to find all the child ... this query stops after one level... what am I missing... thanks for the review.... I'm using sql 2014 WITH Hierarchy ...Unanswered | 4 Replies | 3391 Views | Created by StSingh - Thursday, April 18, 2019 2:24 PM | Last reply by Will_Kong - Friday, April 19, 2019 6:49 AM -
1 Votes
SQL question
In my sql output, I need to get the top 1 column for each unit and acno order by [ref Date] column in desc. So with the following data, I am expecting to get only the following ...Unanswered | 4 Replies | 3681 Views | Created by dper77 - Thursday, April 18, 2019 8:01 PM | Last reply by Natiq Rzazade - Friday, April 19, 2019 6:10 AM -
3 Votes
Is the query optimizer really that smart?
If the SQL in the derived table below (aliased "del") is run independently it takes 1 minute and 38 seconds and returns 969992 rows. Since the stored procedure that contains the code ...Answered | 5 Replies | 4703 Views | Created by Tom Stone 98 - Thursday, April 18, 2019 7:51 PM | Last reply by Will_Kong - Friday, April 19, 2019 3:37 AM -
1 Votes
Parse a pipe delimited string as a target update
Hi all Got an interesting problem but not quite sure how to tackle it. An external app is going to parse me a delimited string of identifiers ...Unanswered | 7 Replies | 1206 Views | Created by James OHara - Thursday, April 18, 2019 10:57 PM | Last reply by pituach - Friday, April 19, 2019 3:19 AM - Items 1 to 20 of 92603 Next ›
No announcements
