T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Delete From Scripting Help

  Hello – I currently have an SSIS package running and the first part of it deletes all data in (Tabl…

  david.ostrander

  3 replies

  11 years, 11 months ago

  By: david.ostrander

• Case Select Sum

  I have the following sql: SELECT Id, Name, CASE ( (SELECT SUM(Revenue) FROM myTable WHERE…

  davidc-765016

  8 replies

  11 years, 11 months ago

  By: hanif.zahid

• CTE

  I've just started to use CTE's to concatenate individual row values into 1 field and I'm liking the…

  ychen 55059

  26 replies

  11 years, 11 months ago

  By: Dwain Camps

• Contains Exception

  I am using sql server 2005 The filed r_resume_text data type is text When i run the Below query i …

  suresh0534

  2 replies

  11 years, 11 months ago

  By: R. Brush

• Trying to join tables on different dates

  Hi, I have a project I'm working on that has two SQL tables. I need to create a query that joins th…

  krypto69

  5 replies

  11 years, 11 months ago

  By: Steven Willis

• cursor for inserting one record at a time

  i need to insert records from table1 to table 2 out of 15 columns from table1 i need to insert 6 …

  ssurekha2000

  3 replies

  11 years, 11 months ago

  By: Dwain Camps

• inserting horizontal records from table1 as vertical records in table2

  i have table with horizontal records , which i need to insert in another table as vertical records …

  ssurekha2000

  7 replies

  11 years, 11 months ago

  By: ssurekha2000

• using isnull function in select query

  select isnull(id,0)+1 as ID from TABLE1 i have the id field blank with defualt value as 0 but when …

  ssurekha2000

  6 replies

  11 years, 11 months ago

  By: shirisha.0301

• Deleted items still appears in output

  Hi All, I'm a real newbie in SQL. My job demands me to learn it which I found out to really attract…

  hidayah

  13 replies

  11 years, 11 months ago

  By: Mark Eckeard

• reading XML in a loop.

  I want to read through an xml document with a loop. I've removed the extraneous code. I get this …

  ethanstout2008

  6 replies

  11 years, 11 months ago

  By: ethanstout2008

• How to make this block dynamic?

  I'm just not sure how to do it. When I run: select @liststr = coalesce(@liststr+',' ,'') + quotena…

  sqldriver

  7 replies

  11 years, 11 months ago

  By: sqldriver

• select where patient has more than 1 provider

  Can someone show me how to select all patients that hasve seen more than one provider over the past…

  Vertigo44

  12 replies

  11 years, 11 months ago

  By: Sean Lange

• Output results to text file

  I need to output a result set into a text file.. not just in the form of data.. i need the rows and…

  Nisha-475382

  13 replies

  11 years, 11 months ago

  By: vikas.helpfriends

• Convert Row to Column

  Hi, I have some challenging requirement of getting rows to columns (i.e 20130701, 20130801, 2013090…

  shahmihir000

  6 replies

  11 years, 11 months ago

  By: shahmihir000

• Need to optimize/Rewrite this query..

  Implement a function with below logic in an efficient way ...Pass @var1 and return @var2 ...How can…

  Chinna

  4 replies

  11 years, 11 months ago

  By: ChrisM@Work