T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 months ago

  By: Eugene Elutin

• INSERT INTO SELECT WITH ORDER BY

  I have a question 🙁 IF i insert into a table with identity column. EX DECLARE @AAAATABLE TABLE( K …

  nguyennd

  39 replies

  15 years, 2 months ago

  By: Paul White

• Select statement with Group BY

  Hi, if we are trying to add the several columns in select statement and only one condition in group…

  Vinay Theethira

  5 replies

  15 years, 2 months ago

  By: Paul White

• data points

  Hi, I've performed some joins on tables and also performed some ETL tasks to get data from one serv…

  tripri

  1 replies

  15 years, 2 months ago

  By: Jeff Moden