T-SQL

• Topics

  Started by

  Posts

  Last post

• Converting data with apostrophes in it

  I have data coming from one table to another table using ASP backend to insert the data I believe. …

  dwjongbloed

  5 replies

  15 years, 9 months ago

  By: Luke L

• how to Split DateTime value in seprate date and time column

  hi all, I have problem with split DateTime value in two separate column in Sql. Example-- Suppose …

  soni.praveen12

  21 replies

  15 years, 9 months ago

  By: Jeff Moden

• the conversion of a char data type to a datetime data type resulted in a out-of-range datetime value

  Hi There, I am getting the following error when I am calling a view from Excel. When I run the vie…

  TSQL Tryer

  1 replies

  15 years, 9 months ago

  By: Simon Liddle

• what is the difference between CAST and CONVERT Function?

  what is the difference between CAST and CONVERT Function?

  rajiv.gupta

  5 replies

  15 years, 9 months ago

  By: amitsingh.gniit

• select comma Separated values

  Hi, I have one temp table with two columns, contain the values like.. Id Name ------------- 1 …

  RamG

  7 replies

  15 years, 9 months ago

  By: Jeff Moden

• Need window functionality in SS2K

  I am probably just missing something fundamental, but I need a way to get two pass style results in…

  DavidKBennett

  1 replies

  15 years, 9 months ago

  By: GSquared

• Dynamic Pivot Table without Aggregrates

  Newbie, Have 1 table, need to convert rows to columns Example: Col1 Col2 1 ABC 2 DEF…

  brvsra7479

  2 replies

  15 years, 9 months ago

  By: pxt_ce

• Enforcing multiple columns updated thru trigger

  I am trying to create a trigger that will fail an update to a specific table when a certain column …

  AVB

  2 replies

  15 years, 9 months ago

  By: AVB

• using outer query column name in subquery while doing order by

  using outer query column name in subquery while doing order by caluse ex: Select name,id,school fr…

  ganaparthi.jagadeesh

  3 replies

  15 years, 9 months ago

  By: Gail Shaw

• Query Table1 takes result rows and create Table2 columns Dynamically

  Table1 query results: A B C D Create new table with columns A B C D Dynamically

  brvsra7479

  1 replies

  15 years, 9 months ago

  By: Jeff Moden

• correlated subquery help

  topic closed

  aoce93

  4 replies

  15 years, 9 months ago

  By: aoce93

• column datatypes

  hello all i wrote a script that takes event viewer messages, manipulates a string for my purposes a…

  itsmeman

  1 replies

  15 years, 9 months ago

  By: ganaparthi.jagadeesh

• "Write once" table column?

  I want to INSERT data into a table with a column called "WriteOnceReadOnly". So after the data is …

  Barkingdog

  1 replies

  15 years, 9 months ago

  By: Jack Corbett

• delete duplicate value

  How to delete the duplicate value in the table..

  karthikeyan-507706

  9 replies

  15 years, 9 months ago

  By: rcassis-1001343

• Returning OUTPUT variables from a stored procedure via OPENROWSET

  Good day, Please help with suggestions. I have a stored procedure that runs on a remote server and …

  vatreni

  1 replies

  15 years, 9 months ago

  By: artralv