T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• SELECT ... FOR XML returns NULL in 2008 but works OK in 2005

  The following code example returns NULL on SQL Server 2008 (in the context of msdb) but works fine …

  kl4576

  9 replies

  15 years ago

  By: kl4576

• Help with SELECT query between certain time-frame

  Hi guys, our developer is not in today and I need help to generate the following query in a dynamic…

  Daniel Sempere

  11 replies

  15 years ago

  By: andrewd.smith

• Sending email and setting calendar from trigger

  Hi I want to create a trigger in my Absence table so when an absence inserted, it sends an email to…

  Kati Sarab

  5 replies

  15 years ago

  By: Lowell

• SQL 2008 R2 - Syntax Error

  I encountered this strange behavior with SQL 2008 R2 Query Parser. The following proc parse succes…

  davidnguy

  1 replies

  15 years ago

  By: nigelrivett

• question on create type in sql server 2008

  In SQL server 2008, I can create data type and then use it to add/modify the colum based on that ty…

  sqlblue

  2 replies

  15 years ago

  By: sqlblue

• A Simple Way to Get Row Counts from Multiple tables

  Hello Everyone Is there an easy way to get the row counts from multiple tables in a database? I am …

  AndrewSQLDBA

  5 replies

  15 years ago

  By: Lamprey13

• date calculations

  Greetings (again). I hope this is quick and painless. How can I obtain current date + 1 day -3 cale…

  simflex-897410

  7 replies

  15 years ago

  By: simflex-897410

• Not able to run an exe file

  Hello There, Please help me with the below issue. I have an exe file which will create an e…

  naresh1253

  7 replies

  15 years ago

  By: Adiga

• dynamic stored procedure query paln

  if we run the dynamic stored procedure, based on the input criteria given to the sp query formation…

  pb-916752

  7 replies

  15 years ago

  By: caladba

• Script runs on 2000 but not any other.

  This query runs fine on 2000 box, but fails on any other. Why isn’t it skipping where @sqlversion…

  SQLHeap

  2 replies

  15 years ago

  By: SQLHeap

• How to compare two columns.

  Hi, I got two tables and i need to join them based on some results That is i need to compare a part…

  tripri

  1 replies

  15 years ago

  By: Derrick Smith

• If statement

  Hi I got to join two tables based on some conditions If COLA contains 'xyz' then i use one join st…

  tripri

  5 replies

  15 years ago

  By: tripri

• Get filtered result set from CTE

  Good afternoon folks, I could use a little help/advice with extracting some data from a CTE. I have…

  chris.king

  14 replies

  15 years ago

  By: chris.king

• Julian date to regular date conversion

  I have a column called paiddate in a table called Checks, and the value in this column is in julian…

  QQ-485619

  3 replies

  15 years ago

  By: Philipp Post

• CREATE INDEX failing after changing collation on table.

  Hi All, I dropped an index to change the collation of a column and now I am getting the following e…

  gbd77rc

  2 replies

  15 years ago

  By: gbd77rc