T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

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

  By: Paul White

• Problems With Update

  I'm having a problem that I can't figure out. I've spent the last hour on a Update statement and i…

  jordon.shaw

  7 replies

  15 years, 7 months ago

  By: Jeff Moden

• Using results of an EXCEPT query

  I have written the following except query... select PtID, MedID from dbo.Pyxis except select [Hospi…

  lulu_lutz

  6 replies

  15 years, 7 months ago

  By: Evil Kraig F

• Joining to two One-to-Many tables - should be simple

  I'm sure this must be answered somewhere in this forum but I couldn't find it. I have a primary tab…

  Ed Srdoc

  16 replies

  15 years, 7 months ago

  By: mtassin

• Finding Repeating Amount (more than 1 as group)

  Hi All, I have table (Balance_due) in the following format: ---------------------------------------…

  karthik M

  9 replies

  15 years, 7 months ago

  By: LutzM

• t-sql help please

  I need to restore the database daily using a scheduled SQL job. Below is my requirement: First time…

  Mh-397891

  1 replies

  15 years, 7 months ago

  By: RichardDouglas

• Index Fragmenaton linked wth Table

  Hi All, I normally use sys.dm_db_index_physical_stats to figure out Fragmentation. Now i want help…

  fawwad

  2 replies

  15 years, 7 months ago

  By: RichardDouglas

• Help with the Stored Proc

  Hi, I have a strored proc which gives the following output :- ServerId day Status 1 …

  ssismaddy

  8 replies

  15 years, 7 months ago

  By: Jeff Moden

• Need help with writing TSQL

  Hi, I have a table with two columns i.e. ChangeDate and StepId. I need a third column 'status' at …

  rajg

  14 replies

  15 years, 7 months ago

  By: Jeff Moden

• vbscript to delete files over certain days old

  I need some help to develop a vscript task to delete files over 14 days old. The files are located…

  QQ-485619

  3 replies

  15 years, 7 months ago

  By: Paul White

• Recursion counting problem. Not your usual issue

  Hi learned people, I have the following tables: Category <---This has the tree structure for t…

  billyholliday

  12 replies

  15 years, 7 months ago

  By: Jeff Moden

• TSQL Best Functionalities needed

  Hi for the below questions i need good and efficient answers. Below are the inrterview questions as…

  srinadh.ramineni

  14 replies

  15 years, 7 months ago

  By: srinadh.ramineni

• Best TSQL Solutions Needed

  Hi for the below questions i need good and efficient answers. Below are the inrterview questions as…

  srinadh.ramineni

  1 replies

  15 years, 7 months ago

  By: ps.