T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• ##Tables in concurrent environment

  Hi All, In an unavoidable situation, I'm using ##Table in my stored procedure. How will it behave i…

  Anamika

  21 replies

  14 years, 10 months ago

  By: Jeff Moden

• Delete from the same table in mutiple databases

  I have many databases on one server that have the same table. I need to delete the contents of the …

  lulu_lutz

  4 replies

  14 years, 10 months ago

  By: Sean Lange

• Hierarchy Product struture in relational database

  I am currently trying to prepare a dimension table for one of our reporting cubes in SSAS. The dime…

  eseosaoregie

  2 replies

  14 years, 10 months ago

  By: eseosaoregie

• Two Variable Combination Permutation Calculation

  Hello- I have a table, DEV_QRY_QC_HCC_131. It has two columns qry_id and hic_number (a member ID). …

  jfanning

  9 replies

  14 years, 10 months ago

  By: jfanning

• How not to get dubs

  Hello, I need to insert data from table 1 and table2, table 2 table is not accepting dubs, That tab…

  Krasavita

  8 replies

  14 years, 10 months ago

  By: LutzM

• Searching and selecting a recurring string from within a variable length field

  Hi I need to select only the characters 'M0', 'M1' or 'M2' (or preferably just the numbers 0,1,2) f…

  Canazei65

  4 replies

  14 years, 10 months ago

  By: Canazei65

• Why is table locked while INSERTING?

  I have a weekly DTS package that executes a stored procedure every week. This stored procedure inse…

  Ray Cacciatore

  4 replies

  14 years, 10 months ago

  By: Evil Kraig F

• Need to your help - Query to display single column values into multiple columns (Cross tab Query)

  Attached .xls file with sample data, Please help me with the query. Thanks in advance. Please see t…

  lookpete

  2 replies

  14 years, 10 months ago

  By: Terry-239890

• XP_CMDSHELL to get files in UNC path

  I'm trying to get a list of files to delete from a UNC path using a very simple command: EXEC maste…

  ImYourDBA

  5 replies

  14 years, 10 months ago

  By: ImYourDBA

• multiple results from single record with startdate - enddate

  I have a table of events with start dates and end dates. If I have a record that looks like this...…

  Andy Urban

  1 replies

  14 years, 10 months ago

  By: Andy Urban

• in a select clause, include a column if it exists, or just return null if not

  presuming i have table abc (col1 varchar) on some production servers and i have table abc (col1 var…

  mitz 39799

  1 replies

  14 years, 10 months ago

  By: GSquared

• Results from different tables, but separate rows?

  Hi, I have run into a little bit of a stumper. I have 3 tables that I am trying to return records…

  upstart

  4 replies

  14 years, 10 months ago

  By: GSquared

• Query for subtraction from main total for each record

  Hi EXPERTS IAM HAVING THIS QUERY select a.U_Amount as 'TOTAL VALUE',b.DocNum as 'INVOICE' ,b.DocD…

  chintalagiriprakash

  1 replies

  14 years, 10 months ago

  By: Jeff Moden

• Date Conversion

  I am looking for the best way to achieve a date conversion. I have a job that will run daily at an…

  dmc-608719

  4 replies

  14 years, 10 months ago

  By: john.arnott

• Datewise Cummulative total for particular customer

  Hi Sql Experts i need help in this query .My requirement is i want datewise and customer wise cummu…

  chintalagiriprakash

  11 replies

  14 years, 10 months ago

  By: Jeff Moden