T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• HR Awards - date problem

  I have a query that I'm trying to write for our HR dept. They need to know when and who to send out…

  krypto69

  3 replies

  12 years, 12 months ago

  By: krypto69

• Why does my scalar funtion not complete?

  I have a scalar function that used to work fine and now doesnt complete. the weird thing is that if…

  BenWard

  10 replies

  12 years, 12 months ago

  By: BenWard

• Date issue - one week

  Hi, I have this query, works fine: SELECT MAX(EC.eecDateOfTermination) FROM EMPCOMP EC WHERE EC.Eec…

  krypto69

  13 replies

  12 years, 12 months ago

  By: Andy Hyslop

• Updating first three characters

  I have a table with a field in it called branchcodes. My problem is the branchcodes are wrong, but …

  krypto69

  5 replies

  12 years, 12 months ago

  By: SGT_squeequal

• Time difference bewteen two different data rows

  hi, i want to show time difference between two datetime fields like here IF OBJECT_ID('TempDB..#myt…

  MuhammadShafiq

  5 replies

  12 years, 12 months ago

  By: davidandrews13

• sp_MsForEachDb with variable

  I need to execute the following query againts all database in an instance. It would return me the l…

  LOOKUP_BI-756009

  4 replies

  12 years, 12 months ago

  By: spaghettidba

• Query Taking ages to execute

  Hi, Please bear with me if the post is too long. I'll try my best to make you guys understand my re…

  vinu512

  10 replies

  12 years, 12 months ago

  By: vinu512

• Distinguish records on daily basis

  i want to divide records on daily basis like here IF OBJECT_ID('TempDB..#mytable1','U') IS NOT NULL…

  MuhammadShafiq

  3 replies

  12 years, 12 months ago

  By: rhythmk

• Getting Duplicates

  I have this query that produces duplicate employees. They are in different companies (orglevel2) bu…

  krypto69

  3 replies

  13 years ago

  By: krypto69

• Insert data into single table from multiple tables

  Hello Please Help me OUT, I am trying to insert data from different tables into single table Say …

  abhi777_aiwa

  9 replies

  13 years ago

  By: Eugene Elutin

• easy way to extract data to csv?

  Hi Guys, just a quick one, I'm extracting data to a CSV for an accounts reconciliation and really w…

  BenWard

  6 replies

  13 years ago

  By: Jeff Moden

• All INDEX details query - gives duplicate entires

  HI, I mixed and matched many queries tto give all details of index needed for analysis. Howeever, t…

  sqlwars

  4 replies

  13 years ago

  By: jeffem

• Very simple query that has me stumped...

  I feel very stupid but can't fathom this: I have a constantlt refreshed table always with 5 rows an…

  rarara

  18 replies

  13 years ago

  By: Davio

• Trying to Find the Right Font

  This may seem silly to some, but I work in the SQL Text Editor most of the day. Because of that, I …

  ducksql@gmail.com

  8 replies

  13 years ago

  By: Eugene Elutin

• Add invoice in stored procedure

  Hey How are you there ? I have to create stored procedure , i can do that but the difficult part is…

  3935

  7 replies

  13 years ago

  By: David Webb-CDS