Topics
Started by
Posts
Last post
Hi, As below script output SQL Statement grouped by their cumulative CPU resource consumption. How …
2 replies
I think that this problem has to have been solved before, but I haven’t been able to find a solutio…
12 replies
Hi, I was wondering what is the best way to change context within a DB. For example you could have …
4 replies
Hi, I am planning to automate restoration process of all db's on test server with latest full, diff…
2 replies
Hi, I have become a bit stuck with this script I am building, any help would be appreciated. DECLAR…
2 replies
Can I use two ddl after with cte statement? The first ddl is to use a merget statement to update a …
5 replies
Hi I have an emergency Phone Numbers table and it has got some duplicate records. Duplicate is defi…
4 replies
I'm struggling with what would seem quite easy... I have two tables tblBank and tblBook... I'm gett…
2 replies
Hello we have a detail table in our erp systm that generates timestamp and message info per order. …
5 replies
I have a table Create table testmuljobs ( AutoID int Identity(1,1), JobID int not null, AcctID int…
4 replies
I stuck on a recursive query. I'm trying to pull a parent and all of the subsequent levels. My data…
4 replies
HI All, Can any one help me how to create COMPUTED columns on DATEADD(yy, -1, GETDATE()) ? Exis…
1 replies
my table looks like invoice_no model_ref item_type item_no invoice_qty tn/000…
1 replies
The DATEADD function is Deprecated. What is the best way to achieve the same results without advers…
4 replies
I'm having issues with the following query. I'd like to use the index on the Date_Created field so…
2 replies
Viewing 15 topics - 2,566 through 2,580 (of 10,647 total)
You must be logged in to create new topics.