T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• How to Minus X amount of minutes in a T-SQL query

  (note: @time = application passes number of minutes) Im using the following query and need help to …

  AHWB

  14 replies

  15 years, 5 months ago

  By: animesh.a

• sp_detach

  I need to do sp_detach but I can`t because says me that the database is currently in use. I closed …

  sistemas_casinomnes

  7 replies

  15 years, 5 months ago

  By: scott.pletcher

• Calculate Working Hour Query

  Hi All, I am maintaining a login and logout in my web application. My tables entries as below. SNO…

  shatrughna

  25 replies

  15 years, 5 months ago

  By: Eugene Elutin

• What columns are eligible to be in non clustered index

  Hi, I'd like to know if there is any criteria to be able to reference a column in a non clustered i…

  xzd000

  14 replies

  15 years, 5 months ago

  By: DataDog

• Rounding in group by with rollup

  Hi all, I currently have a script which summarizes data using the group by with rollup command. I w…

  shlin

  6 replies

  15 years, 5 months ago

  By: LutzM

• How to do - While Loop, Courser, CTE ???

  I have situation where I am pulling customer order information on daily basis through my stored pro…

  keyun

  4 replies

  15 years, 5 months ago

  By: WayneS

• Pivot

  Hello, I am trying to count distinct employees by month for each department. Below is my source tab…

  UnionAll

  2 replies

  15 years, 5 months ago

  By: UnionAll

• Jobs Script

  Hi All, I need a script which should provide the information about the jobs and which job is runnin…

  Raghavender Chavva

  3 replies

  15 years, 5 months ago

  By: Raghavender Chavva

• SQL Query Help

  Hi, I have two tables like application and user application. Now i want to take the application id…

  RamG

  1 replies

  15 years, 5 months ago

  By: Dave Morrison

• Error! Msg 103, Level 15, State 4, Line 1

  Hi, I have a SP where i have to separate the values in to a table. it comes as a collection when t…

  Anamika

  8 replies

  15 years, 5 months ago

  By: Brandie Tarvin

• SQL Challenge

  Morning all, I'm stuck. I have a table: int(mb) datetime 1 2010-07-01 09:21 35 …

  baby_cheeses

  2 replies

  15 years, 5 months ago

  By: baby_cheeses

• Could not find stored procedure 'master..xp_varbintohexstr'.

  I have recently migrated from 2000 to 2005 when i run a SP in 2005 ..I am getting this error ......…

  dheer

  6 replies

  15 years, 5 months ago

  By: Cadavre

• Set Ansi_Nulls Off Not Working in my store procedure

  Dear Sir, I have created a store procedure which insert data into a table. but before inserting dat…

  deba_20032004

  2 replies

  15 years, 5 months ago

  By: Ken McKelvey

• delete multiple rows

  Hi All, I'm building a table which tracks the events that happen to items through a warehouse. Each…

  spin

  1 replies

  15 years, 5 months ago

  By: Gail Shaw

• Need to see if a record exists before I insert into the table

  I need to be able to run an insert but with a precheck to see if the key of my new inserted record …

  bryan.duchesne

  5 replies

  15 years, 5 months ago

  By: David.Poole