T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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, 7 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, 7 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, 7 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, 7 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, 7 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, 7 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, 7 months ago

  By: PhilPacha

• Find pattern of data from three tables

  Hey everyone

  SS-5403

  4 replies

  14 years, 7 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, 7 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, 7 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, 7 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, 7 months ago

  By: Roy Ernest

• Loading Web Page Source from T-SQL

  Hi, Is it possible to connect to a url and load the web-page source from that url, from within T-SQ…

  doplussee

  7 replies

  14 years, 7 months ago

  By: doplussee

• SET STATISTICS IO setting increases CPU time

  Greetings People! I am seeing a wierd thing in my SQL Server. I was doing some performance optimiza…

  ColdCoffee

  3 replies

  14 years, 7 months ago

  By: ColdCoffee

• SQL XML Update Query help required

  Hi, I'm having a table with 10 columns in SQL server, From my frontend .NET application i'm generat…

  User7766

  1 replies

  14 years, 7 months ago

  By: User7766