T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Replacing Hierachy Text value with IDs

  Hi, Its been a while since i have done procedural SQL so would appreciate any help you can give to …

  Intrepid121

  1 replies

  15 years ago

  By: Orlando Colamatteo

• Unable to export to excel using BCP

  Hello All, I am unable to export the output of the following query to excel using bcp. The Code / T…

  mihir.nasikkar

  6 replies

  15 years ago

  By: mihir.nasikkar

• How to make a formula with a weighted scale?

  I am trying to make a formula as follows via a few input values. This is to be a cross reference s…

  dandenson

  5 replies

  15 years ago

  By: dandenson

• Simple query (for you guys and gals)

  All I am having some trouble with a query concept. I know this will be easy for you but it is kick…

  john-902052

  9 replies

  15 years ago

  By: Jeffrey Williams

• Listing results in a single column

  Hi guys . . . I'm guessing that this has been asked before, but I'm going to ask again, anyway. I …

  Ray K

  22 replies

  15 years ago

  By: trevelvis

• Saving the output of a script in a .sql file

  I am trying to write a sp that our support staff can use that will dynamically create a bunch of in…

  kjimenez-1155302

  1 replies

  15 years ago

  By: Saurv

• Update Query

  Hi: I have this query (below). MaterialDesc is the fieldname, and I want to append data to the val…

  steve.anderson 7639

  14 replies

  15 years ago

  By: Sean Lange

• Add the Sum fanction in query

  hi I'm try to sum the following columns{see query below}( CGTResults.UsableCapitalGain and CGTResul…

  GOODS

  1 replies

  15 years ago

  By: GOODS

• Converting a string to Time format

  Hi, On my database we are storing the time in a column which has a datatype set to varchar(max). Ex…

  Hakuna Matata

  5 replies

  15 years ago

  By: Hakuna Matata

• Join to at least one record as default

  I have a table which lists finance reporting units (RU), buisness units(BU) and there respective co…

  eseosaoregie

  6 replies

  15 years ago

  By: ChrisM@Work

• help with dupicated values in dimension and facts

  I have a situation in DWH where one of the dimension is not loading properly which is product dime…

  Sachin4all

  1 replies

  15 years ago

  By: Paul White

• Varchar to Numeric conversion error.

  Hello, i have the following SQL that is generating a conversion error. Any ideas why? SELECT tl.l…

  David Kranes

  2 replies

  15 years ago

  By: Paul White

• Generate all possible characters for UNICODE using SQL Script

  I need to test some functionality for UNICODE. I would like to generate all possible characters for…

  Murthy-152277

  13 replies

  15 years ago

  By: Jeff Moden

• Index/locking hints - how often are they necessary?

  How often would you say you have to use index and locking hints to force SQL server to do what you …

  md23

  7 replies

  15 years ago

  By: Elliott Whitlow

• Check Table Exists being skipped in SP

  I have the stored procedure below I am working to create. If I run all the pieces individually the…

  sqlsponge2

  7 replies

  15 years ago

  By: Paul White