T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Blocking

  I have a procedure that gets called that at times seems to cause a block that last for avout 15 min…

  Rog Saber

  3 replies

  14 years ago

  By: Rog Saber

• How can i select all dates between date range?

  I have one SQL Table with 2 columns as below Column1: ProductionDate - DateTime - Not NULL Column2:…

  rahulpatel112

  2 replies

  14 years ago

  By: Steve Cullen

• Programmatically creating a table alias

  I was surprised to not find this in BOL, and am having a hard time finding this online, so I'm wond…

  Ray K

  10 replies

  14 years ago

  By: Jeff Moden

• Read Windows Directory - error

  Hi all, I am trying to read a Windows Directory and then have SQL update a table with the informati…

  cleroux

  9 replies

  14 years ago

  By: cleroux

• How to query results in debit and credit column

  Hi SQL Gurus, I would like to run a query to display the amount in a debit and credit column from a…

  yingchai

  8 replies

  14 years ago

  By: ChrisM@Work

• Eliminating Duplicate Rows

  Hi, The output of my query contains duplicate records (i.e. column1 value is similar but other colu…

  prakashp 84206

  27 replies

  14 years ago

  By: prakashp 84206

• How can I return value from function that comes from dynamic sql

  I need to get exchange rate from table. Parameters will be exchange type and date. return will be f…

  aykut canturk

  9 replies

  14 years ago

  By: ChrisM@Work

• Find all tables without a Primary Key

  Is there a script which will report all tables that do not have a Primary Key?

  dbalorenzini

  3 replies

  14 years ago

  By: okbangas

• tset

  Hi SQL Gurus, I would like to run a query to display the amount in a debit and credit column from a…

  yingchai

  1 replies

  14 years ago

  By: yingchai

• Simple select by max date

  Hello, I know there are many ways to return data based on the max date. I have data in which there…

  oradbguru

  9 replies

  14 years ago

  By: Dwain Camps

• Problem using COALESCE with GROUP BY

  Hi All, It's been a while since I have posted in here 🙂 I am trying to update my query to add a cou…

  Ste_P

  5 replies

  14 years ago

  By: dogramone

• Using datediff/dateadd function

  I need help on using date functions. I have to calculate the date on friday for past 8th week. Here…

  nehaCS

  6 replies

  14 years ago

  By: nehaCS

• checking for strings in open row set

  Hello All, I am trying to connect to the table which is in different server. I am using open row se…

  SQL Prog

  2 replies

  14 years ago

  By: SQL Prog

• Keylookup -what is the harm

  Hi Experts, I know that key lookup happens , if any one of the select column that…

  chaithu559

  4 replies

  14 years ago

  By: Steve Jones - SSC Editor

• Updating a column

  Hello All, I have 2 different servers. In that 2 servers I have 2 tables one from each.I need to up…

  SQL Prog

  2 replies

  14 years ago

  By: SQL Prog