T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Multiply two columns in SQL nd store

  Hi, I want to multiply two columns in SQL nd store can anybody help me out in this scenario. Exampl…

  best_yunus

  13 replies

  14 years, 1 months ago

  By: vinu512

• correct the code

  hi, i am trying to get 0 as a value if no of rows is 0 still not getting ,my result set is blank. p…

  riya_dave

  9 replies

  14 years, 1 months ago

  By: Dwain Camps

• Bulk Insert Use a format file stored in SQL

  Hi all I have a list of file i want to Bulk insert using the Bulk Insert command. I also have an XM…

  ashley.wardell

  10 replies

  14 years, 1 months ago

  By: Orlando Colamatteo

• SSIS Expression - Looking for the Typo

  I hope someone can help me. This is driving me nuts. I've got a big file that is tilda delimited. W…

  Brandie Tarvin

  1 replies

  14 years, 1 months ago

  By: Brandie Tarvin

• Odd Behavior of update query

  I executed this query: update table2 set id=(select max(id) from table1) where id=0. It indicates i…

  kapfundestanley

  2 replies

  14 years, 1 months ago

  By: Eugene Elutin

• Date range issue

  Hi Following is the code CREATE TABLE #ProductRate( [ProductID] [int] NOT NULL, [FromDate] [date…

  SQL006

  14 replies

  14 years, 1 months ago

  By: SQL006

• query to delete the records for 5 week older data

  Hi I have table which has to delete the 5 week older data.Please help out. I would appreciate your …

  Jay Pete

  5 replies

  14 years, 1 months ago

  By: Jay Pete

• HTML Report using T-SQL

  Hi, I have prepared a disk space report, but now I want to make it Red Bold wherever %FreeSpace is …

  sqldba4u

  7 replies

  14 years, 1 months ago

  By: Lowell

• Need help on transposing rows into columns

  Dear all, I have a table called TaskProductivity (please refer the attached image TaskProductivity_…

  ramsai1973

  5 replies

  14 years, 1 months ago

  By: Sony Francis @EY

• Changing the select list is changing the rows returned

  SQL 2008 R2 64 bit Enterprise I'm using 2 identical queries as sub queries and doing a left join be…

  TangoVictor

  5 replies

  14 years, 1 months ago

  By: SGT_squeequal

• how to insert ID values into one table so that they match identity values of column in another table

  I have to do a complex insert statement from one source table, which defines the relationship betwe…

  polkadot

  6 replies

  14 years, 1 months ago

  By: Jared

• converting an excel sheet operation and calculation to a function

  I want to perform the following operation I copied the excel spread sheet that has the calculation …

  Sarsoura

  1 replies

  14 years, 1 months ago

  By: Sarsoura

• Removing extra rows caused by left joined data

  Hello - I'm wondering if anyone has some elegant way to handle this problem: I have participant/eve…

  dbursey

  4 replies

  14 years, 1 months ago

  By: Jared

• Need Stored procedure for getting all dates falling on saturday for the given year

  Dear all, Please can anybody help me with a stored procedure which returns all dates falling on sat…

  ramsai1973

  3 replies

  14 years, 1 months ago

  By: Lowell

• Encryption/Decryption

  Hello all, I have a database that is storing SSNs...SO while in development I have set up encryptio…

  asm1212

  11 replies

  14 years, 1 months ago

  By: seth delconte