T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How to change some of the columns in to rows

  Hi, I've a query in which i need to change some of the columns into rows. Please see the example; E…

  rbnwork

  3 replies

  15 years, 11 months ago

  By: rbnwork

• Is It Possible To Create Variable To Hold Insert into Tabloe Variable?

  I have a situation where I have to create a dynamic where clause dependant on params passed into s…

  dndaughtery

  3 replies

  15 years, 11 months ago

  By: Gayathri.Varadarajan

• Remove set of characters between [abcd] using SQL function-Need help desperately

  I have a SP which gets parameter @business like this [abcdef] Client [gdhdnuidd] 1st Party SW testb…

  sammm

  2 replies

  15 years, 11 months ago

  By: WayneS

• Select statement with WHERE clause

  Sorry for naive question (it's so hot on the East Coast!) Query: SELECT * From myTbl WHERE A="20" a…

  valeryk2000

  3 replies

  15 years, 12 months ago

  By: valeryk2000

• Filling a LIst table with Dates

  Hello Everyone Something simple I know. I would like to fill one of my list tables with dates. The …

  AndrewSQLDBA

  1 replies

  15 years, 12 months ago

  By: Lowell

• using the "While" statement with "Begin Transaction and Commit Transaction"

  I develope in C# and would like to use tsql transaction in the database instead of .NET Transaction…

  bainn

  2 replies

  15 years, 12 months ago

  By: Gail Shaw

• difference of dates

  Hi, I need to get difference between dates. That is the time difference between todays date and a p…

  tripri

  2 replies

  15 years, 12 months ago

  By: faheemahmad14

• Simple Group By

  Hi, I have a table called XYZ . This table stores all this information shown below. AdId Class…

  PSB

  15 replies

  15 years, 12 months ago

  By: Dan.Humphries

• How to associate unequal number of rows from two separate tables

  Hi I am having trouble putting the following query together I have a customer's before and after pl…

  BIMind

  2 replies

  15 years, 12 months ago

  By: BIMind

• @@IDENTITY.... @@trancount, @@rowcount

  I avoid using @@IDENTITY in t-sql code because it can return unexpected values: "It returns the las…

  Barkingdog

  8 replies

  15 years, 12 months ago

  By: Michael Valentine Jones

• sp_MSforeachdb/exec sproc - unexpected db context behavior

  EXEC sp_MSforeachdb 'USE [?]; print DB_NAME(); exec DBA.dbo.dba_GetAllTableSizes;' On my 2008 serve…

  ZenDada

  1 replies

  15 years, 12 months ago

  By: ZenDada

• Help with (probably simple) query

  Hi Im sure theres a fairly simple way to do this but its beyond my simple sql knowledge... I have a…

  captcrotch

  11 replies

  15 years, 12 months ago

  By: ChiragNS

• self join in loop in sqlserver

  need help please this is source new proj id old proj id 1077a 1077/ 1077b 1077a…

  rahulsony111

  22 replies

  15 years, 12 months ago

  By: rahulsony111

• Rename Temporary Table Name?

  Is it possible to rename a temp table from #temp to #temp1?

  Mister Ken

  7 replies

  15 years, 12 months ago

  By: Jeff Moden

• Problem with Group by clause

  Hi ! Guys I have a problem here in a SP. The SP is like this : USE IRISDW_B4_FEEDRUN IF …

  Shintu

  7 replies

  15 years, 12 months ago

  By: Eugene Elutin