T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Catch Block: Variables vs System Functions?

  I am creating a single stored procedure to log errors from within the CATCH blocks in my code. I n…

  autoexcrement

  2 replies

  11 years ago

  By: autoexcrement

• Calculating interest between two dates - which is the best data type?

  I have a table with a "from date", a "to date", and a total interest amount. I need to work out, on…

  Griffster

  10 replies

  11 years ago

  By: The Dixie Flatline

• SSMS "Script Table As Create" & Collation

  I am using a database with a CI collation, but where some of the columns in some tables are set to …

  autoexcrement

  2 replies

  11 years ago

  By: autoexcrement

• cross apply or other way

  Hello everybody, I have to export the records of a table in a .txt file but in a strange way (in a …

  antonela

  1 replies

  11 years ago

  By: Luis Cazares

• Recursive CTE? Not Sure How To Do This...

  Hey Gang- I have an interesting challenge which I haven't fully been able to wrap my head around. I…

  autoexcrement

  25 replies

  11 years ago

  By: J Livingston SQL

• Trying to Change an Existing Schedule and Edit Job Steps Using T-SQL

  I learned the other day to use sp_add_jobschedule to add a Schedule to an existing job. Is there an…

  ducksql@gmail.com

  3 replies

  11 years ago

  By: Ed7

• About SET Statements (Transact-SQL)

  Hi Can somebody share some experience about some general set statement in your project? e.g. SE…

  jiangrj1

  1 replies

  11 years ago

  By: Jack Corbett

• DBO.SysJobHistory, how do you get the Job Time?

  In the MSDB MS is storing the information about a SQL Job, and in the DBO.SysJobHistory it has a co…

  dwilliscp

  10 replies

  11 years ago

  By: Lynn Pettis

• reverse lookup? everse lookup? (SELECT x FROM table) IN note LIKE %xy%

  Hi, I'm trying to fix a stored procedure within our production db. We have a notes table where user…

  brian.roberts 69246

  5 replies

  11 years ago

  By: Lynn Pettis

• Need help with creating unique constraint.

  Need help with creating a unique index with clause (SQL Server 2005 SP2). Below is my requirement: …

  Chinna

  16 replies

  11 years ago

  By: Eirikur Eiriksson

• Using CASE Statements

  I'm having some trouble grasping the use of CASE statements (used to using If/Then). I would like t…

  mlwiller2

  10 replies

  11 years ago

  By: MMartin1

• joins

  Hello, how many types of joins and briefly explain them. Regards, sathish.

  sathishmssql

  12 replies

  11 years ago

  By: webappenthu

• Dynamic SQL

  In my stored procedure, I have a variable I have declared: @spot_exists int If I run the following …

  Rog Saber

  5 replies

  11 years ago

  By: Rog Saber

• Conver NVARCHAR to INT

  Declare @A AS NVARCHAR(16) SET @A='1' Select Case WHEN ISNUMERIC(@A)=1 THEN Cast(@A AS int) ELS…

  Viky123

  4 replies

  11 years ago

  By: Viky123

• SSRS Error-"Failed to convert parameter value from a String to a Date Time. (System.Data)

  I have the following stored procedure. It works fine running it in SQL Server but when I run it in…

  chloe82402

  4 replies

  11 years ago

  By: edbennett001