Topics
Started by
Posts
Last post
Hello All, Hope there is a simple answer to this problem. I need to take the following data: Table1…
10 replies
My question is why this code not working I want to check if global temp table exist if no then recr…
5 replies
I have a Merge Statement that uses an OPEN QUERY Statement. I have added a Date_Inserted Column to …
5 replies
I have this SELECT name,cmptlevel,DATABASEPROPERTYEX(name,'Recovery')AS RecoveryModel, DATABASEPR…
4 replies
i have a table[table1] with a field summary which has data as 1-AB-XY 2-OP-AB 1-AB-XY 1-MN-ZZ-AB 1-…
8 replies
Does anyone have a basic example of the use of the OUTPUT CLAUSE in a MERGE Statement? I found exam…
1 replies
With a Merge Statement is there a way to Capture the Insert, Update & Delete Counts? For bette…
7 replies
Hello all. SQL Server 2008 T-SQL question but not necessarily about new features. I am stumped. I a…
13 replies
Hi All, What is the difference between SubQuery and Joins in terms of Performance, I know tha…
4 replies
Hi all, there are two tables, one contains the users, the other contains jobs to be taken by the us…
4 replies
Quick Please 🙂 Please tell me what key phrases will lead me to more information about why some tabl…
13 replies
I need to filter results of a query by Start and End Date. A simple select * from TICKET where cre…
8 replies
I need to filter the statement listed below that it only returns schema that I specify in the WHERE…
5 replies
Hello SQL Experts, I have a Inventory data like below Id|Trantype|TranID|TranDate|Qty|QOH| 1|S|S…
8 replies
I'm creating my first trigger to update a field in another table when a new record is created in an…
5 replies
Viewing 15 topics - 6,256 through 6,270 (of 10,635 total)
You must be logged in to create new topics.