Topics
Started by
Posts
Last post
Hi, I have the following statement UPDATE tbl_service_models set tbl_service_models.Maintenance_Sta…
2 replies
I need to distribute case numbers from a table between the AEs that show up each day. Case Table Ca…
6 replies
Hi, I am trying to get the number of orders booked over the last 4 saturdays over a span of 10 minu…
7 replies
I've been tasked with modifying our ETL process to continue in the event of a load failure. Curren…
8 replies
I'm trying to do something quite odd which may ring alarm bells. Anyway I've a table like this: Ke…
8 replies
I have to insert ~ 20 records each time a procedure in a program runs. The table just has 4 columns…
11 replies
The maximum system-generated unique value for a duplicate group was exceeded for index with partiti…
2 replies
I need help identifying a workaround for an optimizer problem I am having. Basically, I have a tabl…
7 replies
Hi there! Could somebody please help me with my datediff function? I want to add a where condition …
1 replies
Is there an easy way to programmatically export the SQL used to DROP/CREATE all constraints (check,…
1 replies
Hi, I'm trying to allocate some payments to charges on a LIFO (last in first out) basis. I'm strugg…
8 replies
I have a small question, probably a silly one.. When we join 2 tables using left join like below: …
5 replies
Hello, I'm trying to efficiently my stored procedures and jobs in my mssql server. What I want is a…
2 replies
I have tried to rename a column name of a table through script (using alter, rename , modify) but c…
8 replies
Hi, Which query executes faster in sql server 2005, if table has some 50k rows. select count(id) fr…
10 replies
Viewing 15 topics - 5,836 through 5,850 (of 12,234 total)
You must be logged in to create new topics.