T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Extracting Data from single table

  I am attempting to pull only open tickets from my table. Thing is we have duplicate records with d…

  dthmtlgod

  11 replies

  13 years, 5 months ago

  By: ChrisM@home

• which is the easy way to Eliminate the duplicates?

  Hi, Please suggest me to get the distinct values from below query declare @T as table(id int identi…

  lokesha.b

  11 replies

  13 years, 5 months ago

  By: Jeff Moden

• Convert years

  Hi, Can Anyone help me with this, please I have a Table like this Es Year January Feb…

  hugo_17_23 19942

  5 replies

  13 years, 5 months ago

  By: Jeff Moden

• Loop Through the records - send email - set the value of the field - Need Code Help

  -- I am hoping not to use cursor -- Query is select * from Orders where EmailSent = 0 --I want to …

  skb 44459

  9 replies

  13 years, 5 months ago

  By: Jeff Moden

• timestamp

  my table need to store timestamp in 1 column, for the record, hwo to create timestamp in sql create…

  harri.reddy

  4 replies

  13 years, 5 months ago

  By: TomThomson

• check constraint

  hi my field only accept two values , 01,02 which is numeric i need to have check constraint , my qu…

  harri.reddy

  3 replies

  13 years, 5 months ago

  By: harri.reddy

• create table

  hi i am getting files which data i need to store in table. i need help with data type for character…

  harri.reddy

  4 replies

  13 years, 5 months ago

  By: joyento.acs

• Updating XML

  I need to update table Cart.Storage which has XML. In particular the <Removable> needs updat…

  chrismat

  8 replies

  13 years, 5 months ago

  By: chrismat

• Which way is better? To join or not to join or does it matter?

  I'm writing a script that will probably join a bit more then 20 tables. It's my understanding that …

  Mike.Hahn

  13 replies

  13 years, 5 months ago

  By: Gail Shaw

• how to show single column value (separated by ;) as multiple columns otherwise null

  in my student table i have a column called as Subject, it has values as below Student IDSubject 10…

  asita

  9 replies

  13 years, 5 months ago

  By: CapnHector

• SSIS Package Inside Trigger keeps running endlessly

  Hi, Following some requirements, that came in yesterday, I have been assigned a task of executing a…

  vinu512

  15 replies

  13 years, 5 months ago

  By: Bhuvnesh

• Need to filter large CTE in Join or where clause

  So I have a fairly large CTE in a stored procedure. I want to filter my results based on an parame…

  computer.mike

  4 replies

  13 years, 5 months ago

  By: The Dixie Flatline

• Looking for Jeff Moden xp_cmdshell article

  I keep finding mentions of an article by Jeff Moden discussing 2-3 options on how to use xp_cmdshel…

  Gabriel P

  2 replies

  13 years, 5 months ago

  By: Gabriel P

• store datatype

  hi i need to store number(2) data type in sql.what should i use ,if i use numeric(2) give sme error…

  harri.reddy

  2 replies

  13 years, 5 months ago

  By: The Dixie Flatline

• Data dictionary procedure issue

  Hi..I have lots of lots of (around 1000) tables for which I need to create a data dictionary..The c…

  rockstar283

  4 replies

  13 years, 5 months ago

  By: vikingDBA