T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Multi part identifier could not be bound error

  Hi when i try to run this query getting error malti part identifier Rpt.fullname couldnot be bound …

  ry.sqldev

  4 replies

  15 years ago

  By: shump66@yahoo.com

• Question on Recursive

  I have three tables in my database as follow: select BrandName, ProductName, URL from dbo.ProductsT…

  biren

  7 replies

  15 years ago

  By: LutzM

• Data Loading Performance issues

  Hi all This based on this article http://msdn.microsoft.com/en-us/library/dd425070(SQL.100).aspx Ge…

  shump66@yahoo.com

  18 replies

  15 years ago

  By: Paul White

• Question on Merging two cases

  Hi Pals, There is a variable with 3 possible values 'ISSUED', 'PENDING', 'BOTH' the table in the ba…

  Vishal Singh

  5 replies

  15 years ago

  By: Kingston Dhasian

• Using IS NULL operator query runs slow in 2008, but less than a second in SQL 2000

  This query below retreive 17 rows and run is less than a second in SQL 2000, but since upgrade to S…

  Jamie Wormald

  9 replies

  15 years ago

  By: Jamie Wormald

• For XML RAW

  Hi, How to use For XML RAW in Sub query or derived table using Sql Server 2000 For eg. select * fro…

  lav-888385

  2 replies

  15 years ago

  By: lav-888385

• BOM Summation

  Dear Experts, I have quite a problem here :- I am trying to add up data that sits on tables as s…

  martin.edward

  11 replies

  15 years ago

  By: Sachin Nandanwar

• 2 questions... first x > '' vs x <> ''

  I am struggling to work with an old oracle developer who does some mighty strange things and I was …

  mudbuddy11

  23 replies

  15 years ago

  By: David.Poole

• dec to hex

  Hi All, i have a table that has information regarding version number for particular units. now prob…

  fawwad

  10 replies

  15 years ago

  By: LutzM

• Question about Inserting formatted files in SQL Server DB

  Hello All, I have a question that you guys may be able to help. There will be some text files in "C…

  Rookie R

  5 replies

  15 years ago

  By: Rookie R

• Select query

  I have following table in my database Brand Model Category Co…

  biren

  4 replies

  15 years ago

  By: Scalability Doug

• get ip from username

  hi all. how to get ip address from username by xp_cmdshell? what comand of xp_cmdshell for this pur…

  elham_azizi_62

  4 replies

  15 years ago

  By: Perry Whittle

• Issues in Identity Column

  Dear all, In one table, i have identity column , how can we update the values in identity column, …

  Saravanan_tvr

  12 replies

  15 years ago

  By: Paul White

• SQL FUNCTION HELP

  Hi all, I have a postcode Lookup table TableA DECLARE @TableA TABLE ( ID [bigint] IDENTITY(1,1) NOT…

  Deepthy

  3 replies

  15 years ago

  By: Deepthy

• difference between index scan, index seek and table scan

  I just want to know the difference between index scan and index seek. I have created two tables wit…

  vamshi.kotagiri

  3 replies

  15 years ago

  By: Paul White