T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• *= non ansi join

  WE have a database that was on SQL 2005 in 2000 compatibility mode and now we're trying to get it t…

  Sailor

  7 replies

  14 years, 10 months ago

  By: Gail Shaw

• replace Nulls with blanks across an entire table

  Does anyone know of a a way to replace "null" with "" across an entire table without having to list…

  LoosinMaMind

  4 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• Add a range of scores to a parameter

  I have a list of scores, anything from 10.00 to 151.80 for example. I need to create a range of 10-…

  fergusoj

  7 replies

  14 years, 10 months ago

  By: fergusoj

• Can I create Email Trigger that compares column value in inserted row with value in another table?

  I want to send out an email to Users if they enter incorrect data into database table. The User wil…

  andrew.sugden

  2 replies

  14 years, 10 months ago

  By: HowardW

• How do we get Total Execution Time in milliseconds where there are lot of GO statements

  Hi All, I have to get the Total execution time in MILLISECONDS of a script which have lot of batche…

  C.K.Shaiju

  7 replies

  14 years, 10 months ago

  By: jasonmorris

• SSIS package changes are not saved.

  Hi, I am opening an ssis package in BIDS and modifying the package by changing one of the connectio…

  sql_novice_2007

  4 replies

  14 years, 10 months ago

  By: Suresh B.

• WHERE clause as a parameter

  I have a stored procedure that returns a recordset. Once and a while I would like to filter out re…

  awsiemieniec

  6 replies

  14 years, 10 months ago

  By: Eugene Elutin

• What's the best way to grab the Grand Total for calculation - TSQL

  Is there an easy way to grab the total for a calculation within a CTE? WITH MYCTE AS ( SELECT MYST…

  sql_jr

  7 replies

  14 years, 10 months ago

  By: Eugene Elutin

• Query not working in SQL2K8

  Hi, It was working on sql server 2000, not in SQL2K8. select distinct (d.MAC_address) as MAC, d.hos…

  SQL Galaxy

  9 replies

  14 years, 10 months ago

  By: Florian Reischl

• t-sql execute faster

  I would like your suggestions on how to make a sql server 2008 r2 stored procedure to run more eff…

  wendy elizabeth

  5 replies

  14 years, 10 months ago

  By: PhilPacha

• Find pattern of data from three tables

  Hey everyone

  SS-5403

  4 replies

  14 years, 10 months ago

  By: SS-5403

• Stored Procedure (with parameters) into Temp Table without creating table fields

  Stored Procedure A has a bunch of parameters and it's used for an online database. I want to obtain…

  Rob-350472

  5 replies

  14 years, 10 months ago

  By: Rob-350472

• Internal clock times and datediff query

  Hi i have to generate a key in a table by way of concatination. exmaple key : CLINC:CONS:09/09/201…

  LoosinMaMind

  3 replies

  14 years, 10 months ago

  By: John Mitchell-245523

• Would you please provide a simple solution to parse the string?

  I have to parse 2 strings from 2 columns of a table. I did that in 2 different ways. One with SUBST…

  C.K.Shaiju

  1 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• Table valued parameter

  Hey Everyone, Has anyone seen performance issues when using Table valued parameters? The reason why…

  Roy Ernest

  6 replies

  14 years, 10 months ago

  By: Roy Ernest