Topics
Started by
Posts
Last post
I’m looking for clearity on partition switching. The idea is to use many BULK INSERT statements int…
1 replies
Hi, I have this script, it is taking long time to execute, what can I do to make it execute faster…
10 replies
I have a table with dates and values and other columns. In a proc i need to get the result as Month…
12 replies
I am trying to calculate cumulative GPA which is currently it is being done via a cursor and i was …
23 replies
To avoid locking/blocking, or in transaction scope, we are trying make a common practice of writing…
7 replies
On the following merge statement, the insert always occurs. The Insert statement should only occur …
1 replies
Hi friends, I'm looking to see if there is a way to populate starting number for the sequence fr…
3 replies
What is the purpose of creating table variable and inserting data into it and selecting from table …
3 replies
I am using SQL Server 2012 to improve the running time on a user defined function named "udf_GetPac…
8 replies
In the following t-sql 2012 merge statement, the insert statement works but the update statement d…
1 replies
I am currently using 5 separate CTEs and I am wondering if I can use only 1 cte. What I am listing…
3 replies
I have a hierarchical structure for mapping products to categories, categories go 3 levels deep (de…
27 replies
I have three tables: EMP (ID, NAME), EMPDATE (ID, STARTDATE, ENDDATE), YEAR(YEAR) I would like to …
23 replies
Anyone have any tricks to separate this column from: "testlname,testfname comment section > comm…
1 replies
I have these SQL statements inside a WHILE loop : SET @StartDate1 = (SELECT MIN(A.startdate) FROM #…
4 replies
Viewing 15 topics - 2,956 through 2,970 (of 4,984 total)
You must be logged in to create new topics.