T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Do not SELECT if in Table B

  I have the following query for auditing contained sql logins in my sql server instance: SET NOCOUNT…

  Michael_O

  3 replies

  9 years ago

  By: The Dixie Flatline

• how to select first column with a specified value in a day range

  I HAVE A TABLE RANGING FROM MONDAY, TUESDAY,WEDNESDAY,THURSDAY,FRIDAY,SATURDAY,SUNDAY THESE TABLES …

  JALLY

  13 replies

  9 years ago

  By: MMartin1

• Insert Into multiple values from Select plus adding incremental non-Identity

  This seems fairly simple, yet I've never been able to do this without multiple steps. I'm creating…

  Luv SQL

  12 replies

  9 years ago

  By: drew.allen

• difference betwwn inner join and intersect in sql

  I would like to know when to use inner join/outer join and intersect/except as they probably are do…

  sej2008

  8 replies

  9 years ago

  By: Luis Cazares

• return minimum records

  Hi I have the following table CREATE TABLE TempTable( RowID INT, AssetCode VARCHAR(50) NULL, WorkOr…

  Nomvula

  6 replies

  9 years ago

  By: Nomvula

• @@ROWCOUNT when cascade delete?

  Hi, Is there an easy way to see how many rows got affected - both parent and children - when I dele…

  btio_3000

  2 replies

  9 years ago

  By: btio_3000

• CSV split in columns

  Given this: DECLARE @t TABLE(ID INT IDENTITY, [product] VARCHAR(50), [sku] varchar(50), [colour] V…

  james 26258

  1 replies

  9 years ago

  By: The Dixie Flatline

• Need help to write SQL - To create All Cross-Value based on some data

  Hi, I attach my Table and Data - sqlData-20082016-1.zip How to create All Cross-Value based on data…

  Qira

  12 replies

  9 years ago

  By: Qira

• sp_executesql and howto return rowcount

  Hi, I'm using dynamic code but I'm not able to return any rowcount DECLARE @rowDSServernvarchar…

  candide

  7 replies

  9 years ago

  By: candide

• create table dynamically in the SP

  Hi , i have a requirement to create a table on the fly as part of the store proc by grabbing the co…

  Tara-1044200

  1 replies

  9 years ago

  By: Eirikur Eiriksson

• how to get deadlock graph xml in server side trace

  Hello, I have setup my trace definition to save a xdl file, when I export the scripted trace defini…

  dlee20

  3 replies

  9 years ago

  By: Markus Poehler

• Need query for After Trigger on update,delete

  Hi experts, I need a trigger script that will insert a record in Audit table when performing update…

  Satiz

  23 replies

  9 years, 1 month ago

  By: ScottPletcher

• Strange update behaviour

  Okay, I MUST be missing something; update EmpActions set isactive = 'N' where 1=2 When I run this…

  cmullen77 29296

  11 replies

  9 years, 1 month ago

  By: ChrisM@Work

• Date gaps between date spans

  Hi All, Edit - managed to edit the original post. I have data that I need to find missing date gap…

  micang

  4 replies

  9 years, 1 month ago

  By: micang

• How to change Column with row in SQL

  Hello I Have a Table with this Contents: How I Can Get Below Table from A bow table: by the way y…

  a913125

  2 replies

  9 years, 1 month ago

  By: a913125