T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Remove successive rows with same column value

  Hello everyone, I'm a beginner in SQL and i have difficulty to find solution for the folowing probl…

  Med Anwar

  22 replies

  13 years, 11 months ago

  By: Med Anwar

• Write all the records of a table to a text file on the local disk with in T-SQL (SP)

  We ant to Write all the records of a table to a text file on the local disk with in T-SQL. We do no…

  Joe-420121

  16 replies

  13 years, 11 months ago

  By: Joe-420121

• how to separate value columns my matching two flag

  Hi SQL Gurus, I have a requirement here to transform the table and need your advise on this. Below …

  yingchai

  7 replies

  13 years, 11 months ago

  By: yingchai

• RS with two date columns from a single date column

  [not sure that Subject made sense but I couldn't think of a good description for this] I have the f…

  Brian Ki

  9 replies

  13 years, 11 months ago

  By: Jeff Moden

• retrieve only month and year (last two digits) part of datetime field

  I found this statement on line for retrieving only MON-YYYY portion of datetime field. SELECT CO…

  polkadot

  26 replies

  13 years, 11 months ago

  By: polkadot

• Run query it takes 16 seconds run stored procedure never finishes

  I have a stored procedure that never finishes. I run the query inside the stored procedure and it …

  pamozer

  14 replies

  13 years, 11 months ago

  By: pamozer

• BCP cmds BUILDING up in cursor

  I have a cursor which with each loop selects a BLOB and outputs it to a file using EXEC master..xp_…

  Edward-445599

  1 replies

  13 years, 11 months ago

  By: CapnHector

• Count aggregate rows

  Can someone help me figure out the logic on how to deliver the count after I aggregated the rows? F…

  bostonjoey

  5 replies

  13 years, 11 months ago

  By: CapnHector

• How to update/delete rows from different tables (tables have relationship)?

  Hello Sirs/Mams, A pleasant day to every one. I have the following tables and a sample dummy data (…

  marksquall

  6 replies

  13 years, 11 months ago

  By: marksquall

• Handling Multiple transaction

  HI These are the 3 tables •AgencyAccount (AgencyID,AccountBalance) •Ag…

  SQL006

  5 replies

  13 years, 11 months ago

  By: SQL006

• Multiple Select statements for insert into table

  Hi I have a table like as below : Date StoreName ItemID Lcount 11/22/2011 AAAAA …

  Steve Dell

  3 replies

  13 years, 11 months ago

  By: vinu512

• Question about EXCEPT statement returning a row it shouldn't

  hi, i'm stumpped as to why an EXCEPT statement is still seeing a difference between two text value…

  digimetic

  1 replies

  13 years, 11 months ago

  By: digimetic

• String extraction

  string extraction: Hi, 1)IF input = SampleDoc (07) o/p should be sampledoc(07) 2) For '/Customer Se…

  komal145

  10 replies

  13 years, 11 months ago

  By: komal145

• How to calculate the number of minutes between 1900-01-01 00:00:00 and 9999-12-31 23:59:59

  So I was working with a performance metrics table, trying to load it into the DW. One of the tasks …

  mtassin

  6 replies

  13 years, 11 months ago

  By: ChrisM@Work

• Quering filestream data

  Hi, Decided to check out the filestreaming feature. Created a copy of the current table replacing …

  Roust_m

  5 replies

  13 years, 11 months ago

  By: Steve Jones - SSC Editor