T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

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

  By: ps.

• Travel Planner SQL

  Hi All Can someone please tell me if value1 and 2 are on same table how to get a result sets simila…

  cbalasuriya

  8 replies

  15 years ago

  By: Jeff Moden

• How to grouping/collapse multiple rows into a single row?

  Hello folks, I am faced with a challenging T-SQL problem for which I am unable to find a set based …

  Mando2

  6 replies

  15 years ago

  By: Mando2

• Sorting NVARCHAR with ' and - symbols is not sorted properly?

  Hi there, :hehe: Ive been playing around with my code and I noticed this sorting disorder. the symb…

  Quatrei.X

  3 replies

  15 years ago

  By: Johan Bijnens