Topics
Started by
Posts
Last post
Hi Friends, I'm using DateDiff function - my requirement is - 1) "SmartLaborII Job Posting End Dat…
8 replies
Hi, I am going to delete the records for last 2 years, and total number of rows 31935523.. Should I…
2 replies
Table 1: SnoSIDSname 1NullA 2NullB 3NullC 4NullD 5NullE Table 2: anoaIDaName 155…
6 replies
Hi There, Could you please help me out, i have table with 9 columns and about a million rows, i nee…
5 replies
I’m working on the hierarchy lesson in Ken Henderson’s The Guru’s Guide to Transact-SQL. He wants t…
18 replies
I'm attempting to optimize some code that I was just handed, and I'm not exactly sure if what I wan…
12 replies
If I want to Sum a field where the date has passed, how would I do that? So my goal would be to Sum…
4 replies
Hello Everyone I am working on some old data that should not be store this way, but it is. My data …
14 replies
I am looking for a way to optimize a SELECT query that includes a column with a data type text. I c…
17 replies
I have a dilemna. I like to use multi-server quesier to push out my code; however, all my SP's use…
3 replies
Hi, Which will perform faster/better inserting million rows to a table or put all insert in a trans…
13 replies
Hi all, I need to script a query to discard access logs that not exceeding a predetermined margin (…
37 replies
I am trying to create an update trigger that updates isactive field depending on different criteria…
2 replies
Hi, I'm trying to figure out a way to calculate a weighted average, but having trouble with the tim…
9 replies
Hello Everyone Thank you all for the suggestions yesterday. I have written a SSIS package that now …
7 replies
Viewing 15 topics - 4,051 through 4,065 (of 10,636 total)
You must be logged in to create new topics.