Topics
Started by
Posts
Last post
For the longest time, we rarely if ever got an error message about locking, however, another team t…
3 replies
Hi I have a very simple query as below select Personid, StartDate, endDate from table where startda…
8 replies
Stored procedure OUTER_TEST calls stored procedure INNER_TEST. If an error in INNER_TEST, how do I …
2 replies
Hello all, I am new to SQL, how to syntax 2 conditions connected with AND when trying to save value…
6 replies
Dear All As per my request I have following input table Create table #FirstTable( StudYear int, Stu…
1 replies
Hi, I have lite experiece with MS SQL SERVER 2014. I try to write query to get info from order DB. …
6 replies
Hello, So i am using this query below: SELECT TOP(10) @@SERVERNAME SERVERNAME,qs.execution_count AS…
3 replies
Hi all Does anyone know if it is possible that when doing a "SELECT ... INTO #temptable FROM ... …
1 replies
Hi All, I have a big csv file which I'm putting into a temp table with the bulk insert command. Thi…
3 replies
Hi Any ideas on how to improve performance? @strMBRNO VARCHAR(255) AS SET NOCOUNT ON SELECT DISTINC…
9 replies
Hi Error - Each GROUP BY expression must contain at least one column that is not an outer referenc…
4 replies
I was wondering if anyone knew how I can change the Excel rendering format in the reportserverconfi…
2 replies
UPDATE MyTable SET Num = 999 UPDATE MyTable SET Num = 999 WHERE Num <> 999 --ignoring nulls i…
1 replies
I'm after a simple trigger to audit inserts and deletes on a single table. If the PK does not exist…
8 replies
hi, 1) in following query i have changed the second ancher member which was getting father to mothe…
1 replies
Viewing 15 topics - 106 through 120 (of 3,062 total)
You must be logged in to create new topics.