T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Need help with logic

  Hi, Pls suggest a robust logic for the following scenario: Sample Calculation: 12/22/201491 Tod…

  gayesh

  3 replies

  11 years, 1 months ago

  By: Sean Lange

• Truncate vs Delete

  can truncate and delete rollback when we use transactions?

  satishkmr538

  3 replies

  11 years, 1 months ago

  By: Sean Lange

• Can't figure out a case selection

  I need to write a query to get two numbers: one for this week and one for last week, here is my que…

  sonchoix

  2 replies

  11 years, 1 months ago

  By: ChrisM@Work

• unpivot sorting error

  Good day, I am having problem with the unpivot function of sql 2012, i unpivot my column then i get…

  cyberdaemon

  1 replies

  11 years, 1 months ago

  By: ChrisM@Work

• Shredding Complex XML Structure?

  I have an xml file that I need to read out into columns and I'm having a problem with the section t…

  William Cokeley

  2 replies

  11 years, 1 months ago

  By: William Cokeley

• What's the best way to accomplish?

  I've got a web app that needs to dynamically pull/store information for reporting purposes. Let's s…

  MyDoggieJessie

  4 replies

  11 years, 1 months ago

  By: MyDoggieJessie

• Transpose/Pivot textual data

  In our contract management system, each contract has over 100 reference fields attached to it. The…

  Rich Ray

  6 replies

  11 years, 1 months ago

  By: Rich Ray

• I cannot access sql server from the client app?

  hi i have a C# windows app trying to access database based the connection string stored in teh app…

  thephillgreggan

  2 replies

  11 years, 1 months ago

  By: RTaylor2208

• Which is Quicker ? - updating 90 million records

  Hi , Ive got a table of 60 million (ish) records I need to update in chunks Which is the quicker a…

  simon_s

  8 replies

  11 years, 1 months ago

  By: simon_s

• Need help with sequencing

  I have a

  surf4profit

  7 replies

  11 years, 1 months ago

  By: Sean Lange

• Divide using formula from different table in sql

  I need to evaluate a formula in sql server 2008 Table 1 contains Entity Value A 2424053.5000…

  vishal.sahani

  1 replies

  11 years, 1 months ago

  By: Koen Verbeeck

• Avoid using a Cursor

  I am trying to think of a way to read a control table, build the SQL statement for each line, and t…

  dwilliscp

  3 replies

  11 years, 1 months ago

  By: dwilliscp

• Inline table-valued function: A severe error occurred

  I'm attempting to convert some INSERT-EXEC structures into table-valued functions because the proce…

  Stephanie Giovannini

  5 replies

  11 years, 1 months ago

  By: Stephanie Giovannini

• Winscp to get only current days files

  Hi All, I have to download the files from SFTP server, for which i am using WINSCP and i am able to…

  Dhruva_51

  6 replies

  11 years, 1 months ago

  By: Ed Wagner

• error in SQL String by CONCAT

  hi i have 2 table: t1: t1_idint namenvarchar(10) t2: t2_idint t1_idint Sematnvarchar(50) the…

  armm1388

  3 replies

  11 years, 1 months ago

  By: Eugene Elutin