T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• query problem

  i have created a stored procedure which runs Perfect in SQL Server 2008 but producing error in SQL …

  awaisahmad435

  5 replies

  15 years ago

  By: Vedran Kesegic

• Return average from last 12 month with 0 possible

  I have the following query and am a little stuck on figuring out how to return a 0 if there is no d…

  DevNate

  7 replies

  15 years ago

  By: LutzM

• Not exactly T-SQL - command line utilities

  Here's the deal. Our SSIS packages are currently running as Windows Tasks instead of scheduled SQL…

  JustMarie

  4 replies

  15 years ago

  By: JustMarie

• Write query results in tab delimited file and push the file to ftp

  Hi, How do I Write query results in tab delimited file and push the file to ftp on daily basis …

  ramadesai108

  12 replies

  15 years ago

  By: ramadesai108

• Loop Thru a Table

  Dear Sir, I have a Table given below in SQL DB & want to go record by record (Alive to Vinit) …

  Subrata Bauri

  30 replies

  15 years ago

  By: Greg Edwards-268690

• Data format in T-SQL 2005

  Hi All, I need to convert the below format data(data type of ntext) to "mmm-yyyy" ? How to do this …

  Gangadhara MS

  3 replies

  15 years ago

  By: Cadavre

• I need a script asap

  Hi folks, Please let me know if it's possible or not... Suppose we have a sql server 2005 with so…

  sam-1083699

  3 replies

  15 years ago

  By: Jeffrey Williams

• How to concatenate binary variable with string?

  Hello, I am having a problem concatenating a binary variable to a string. A simplified example: DEC…

  john0990

  3 replies

  15 years ago

  By: juanfvc

• Save details of who deleted data from a table

  Hi, How can i save the details of who deleted data from Test table to an audit table, including the…

  Maina-456685

  4 replies

  15 years ago

  By: Sanjay Rohra

• Gaps and Islands with multiple simultaneous insurance coverage?

  Most examples of "gaps and islands" queries I've seen focus on an identity column or when tracking …

  peterzeke

  13 replies

  15 years ago

  By: WayneS

• Problem With Recursive CTE

  I am trying to create a function that returns a bill of materials for a given product. The problem …

  David-155102

  25 replies

  15 years ago

  By: Jeff Moden

• I would like to get the distinct value from specified column. I would appreciate if any one provide the answer of this

  I have table A_ having near 55 million rows. Name column having some duplicates, i would like to re…

  Ruban S

  22 replies

  15 years ago

  By: Jeff Moden

• Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to numeric.

  Error Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to numeric. Select A.C…

  sabareeswaran.sundram

  1 replies

  15 years ago

  By: LutzM

• Error converting data type varchar to numeric.

  hi am geting Error converting data type varchar to numeric. SELECT E.CRT_Cod,C.CP_Nm,R.Ret_MDN,E.Re…

  sabareeswaran.sundram

  4 replies

  15 years ago

  By: LutzM

• Error converting data type varchar to numeric.

  Select A.CRT_Cod,A.CP_Nm,A.TSM,A.TSM_No,A.Lead,A.DSR_NM,A.DSR_no,A.Business_category as 'Trans_Typ'…

  sabareeswaran.sundram

  1 replies

  15 years ago

  By: Gail Shaw