Topics
Started by
Posts
Last post
Hi, I have an existing code in sql server 2000, which after migrating to sql server 2008 the perfor…
19 replies
Hi, in Management Studio you can do for a single index or key the following SCRIPT INDEX AS... DROP…
7 replies
At the moment, my code looks a bit like this: exec dbo.usp_my_stored_proc 1, 12, 10000; exec dbo.u…
2 replies
/*ORIGINAL QUERY. TOTAL ROWS AT THE END ARE 24424 */DROP TABLE #GMTVisionTemp GO DROP TABLE #GMTVi…
2 replies
This code get the the files from Window directory and get the results in the table with all the fil…
5 replies
I need to be able to step through row by row a list of statuses to see if a status of "filed" is th…
5 replies
Hi All, I have two coulmns called RequestID, ApprovalName ex: RequestID ApprovalName Row …
16 replies
I have written below query to get the total of each indicual items with same RequestID(requestitems…
1 replies
Hi Friends, I need a help in creating a function. The problem is described below. CREATE TABLE TB1 …
5 replies
Hi, I need some help as i dont no much about how to pull data from active directory. Now i got some…
4 replies
Hi all, I have table which has columns ModifiedDateTime (datetime),Ignition (bit). Modified Date Ti…
10 replies
Issue: SELECT SOUNDEX('SMITHWICK')--Returns S532 SELECT SOUNDEX('SIMONS')--Returns S552 As you ca…
2 replies
Which way is better way of joining two large tables : Select a.col2 ,b.col2 from table1 a I…
9 replies
Dear All. I want to do data profiling on different database objects and i need to get the following…
1 replies
Does anyone have a link to show how to turn on SQL 2008 Debugging for developers? It's weird, I'm w…
1 replies
Viewing 15 topics - 9,676 through 9,690 (of 10,635 total)
You must be logged in to create new topics.