T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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

  13 years, 10 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

  13 years, 10 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

  13 years, 10 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

  13 years, 10 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

  13 years, 10 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

  13 years, 10 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

  13 years, 10 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

  13 years, 10 months ago

  By: seth delconte

• Aggregates on the right side of an APPLY cannot reference columns from the left side.

  How do you do something like this? I want to replace SUM(X.A)/SUM(X.B) with FX3.Val3 CREATE FUNCTIO…

  ReginaR1975

  1 replies

  13 years, 10 months ago

  By: drew.allen

• Comparing rows in same table

  My question is how to compare rows in the same table. I have processed data and got it into followi…

  jinkazama_11

  10 replies

  13 years, 10 months ago

  By: jinkazama_11

• Excluding Records

  Is there a trick or common way to do the following: Let's say I have a table called People with two…

  Mike Scalise

  6 replies

  13 years, 10 months ago

  By: Mike Scalise

• insert values in table

  hi how can i add something like this in table account's value insert into @temp1('account's value')…

  riya_dave

  8 replies

  13 years, 10 months ago

  By: Sony Francis @EY

• SQL not working as expected - Deleting duplicates from dataset

  Hello - I cannot figure out what is wrong with the following code. Can anyone see what I am missin…

  tammyf

  4 replies

  13 years, 10 months ago

  By: tammyf

• Help with Query(Matrix Format)

  Hi , I have a table Temp and the data as follows. Create table Temp ( PAN nvarchar(100), Month in…

  sandyschiru

  4 replies

  13 years, 10 months ago

  By: adlan

• If proc1 calls procB, can proc1 complete without waiting for procB?

  Current situation: In SQL 2008 environment, proc1 is called by a single-threaded, third-party Windo…

  cs2data

  35 replies

  13 years, 10 months ago

  By: Elliott Whitlow