T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• previous figure

  i have a table with 3 columns. i want to get the salesamount for previous calcid for a perticular p…

  scottichrosaviakosmos

  5 replies

  12 years, 9 months ago

  By: scottichrosaviakosmos

• Interesting query - remove duplicates from my table

  Hi everyone, I need help understanding something. The situation is - I have a table that stores com…

  Oksana March

  9 replies

  12 years, 9 months ago

  By: Rob Schripsema

• Case in where clause doesn't get validated

  Hello, I want to add filter NextReviewDate to the query in the where clause, how come this doesn't …

  halifaxdal

  7 replies

  12 years, 9 months ago

  By: ChrisM@Work

• Advanced (?) SUM

  Hi all! I know this have been done before, but that really doesn't help me, 'cause I can't find the…

  Ola L Martins-329921

  4 replies

  12 years, 9 months ago

  By: Ola L Martins-329921

• Insert, Select on same table

  I have two jobs running. Job2 is kicked off after 3 mins of start of job1. Job1 has a long running …

  bharadwaj.manchu

  2 replies

  12 years, 9 months ago

  By: Jason Selburg

• sql server Data Matrix.

  I have Table A , and table B . table A holds the about the class of a product and table B holds the…

  avssrk

  8 replies

  12 years, 9 months ago

  By: Dwain Camps

• Unexpected Result of Select Statement: Shubham Saxena

  Hi Friends, I am getting unexpected result:Please Explain deeply. SELECT CAST(643 AS VARCHAR(1)) s…

  shubham.saxena67

  6 replies

  12 years, 9 months ago

  By: Paul White

• Variable for the datepart in DATEADD Function

  I am trying to use the DATEADD function by passing in the value for DATEPART from a field to determ…

  cs.asbuilts

  4 replies

  12 years, 9 months ago

  By: cs.asbuilts

• Is it safe to use "update syscolumns set colstat"

  Hello guys, I have a very large table(100,000,000 records), and I have an identity field ,which is …

  Aspet Golestanian Namagerdi

  14 replies

  12 years, 9 months ago

  By: The Dixie Flatline

• database stuck in single user and no spid

  Hi i have a dev database that is stuck in single user mode when i try and access the database i can…

  icampbell

  6 replies

  12 years, 9 months ago

  By: Nils Gustav Stråbø

• Copying Headers from SQL Query Window results in SQL 2005

  I wanted to copy the headers of a query result to a excel spreadsheet. In the grid view mode, by de…

  s-sql

  3 replies

  12 years, 9 months ago

  By: tyson.price

• Print Statement in Trigger

  Please tell me where the results of a print statement can be retrieved when the print statement is …

  jean 93062

  6 replies

  12 years, 9 months ago

  By: Jeff Moden

• SQL not deleting files

  Why is the following statement not deleting the backup files? EXECUTE master.dbo.xp_delete_file 0…

  dwilliscp

  4 replies

  12 years, 9 months ago

  By: dwilliscp

• Compare rows in the same table and group the data

  Hello All, Please point me in the right direction as to where i can start to resolve this problem. …

  sharonrao123

  2 replies

  12 years, 9 months ago

  By: sharonrao123

• Big INSERT INTO and locked table issue

  Hi All, There is a job which executes each day and copy some records from one table to other. The q…

  Boris Pazin

  1 replies

  12 years, 9 months ago

  By: Sean Lange