T-SQL

• Topics

  Started by

  Posts

  Last post

• PRINT in sp with empty output

  In a sp I have added a few PRINT-statements to show intermediate results. The output is empty at a …

  Michael Baas

  8 replies

  17 years ago

  By: Michael Baas

• "=*"

  :hehe: I am in the process of trying to make db projects in VS2005 TFS. I am getting an error in …

  Angelindiego

  6 replies

  17 years ago

  By: Angelindiego

• Question on DATEADD

  I have this AND clause: AND c.DateCreated BETWEEN DATEADD(YEAR, -5, GETDATE()) Is this correct? Wh…

  Arthur.Lorenzini

  5 replies

  17 years ago

  By: Lynn Pettis

• SYNTAX ERROR during CAST

  I am using CAST to extract the numeric portion of a given string (which should have been constructe…

  Michael Baas

  3 replies

  17 years ago

  By: Michael Baas

• UPDATE Name field

  I have 2 tables as ahown below: tbl_DEMOG1 PATID Name DOB …

  eseosaoregie

  1 replies

  17 years ago

  By: Garadin

• How to findout the length of a string variable in sql server 2000

  i did this for triming : ltrim(rtrim(strVar)) , and here i have to know the length of this string…

  Anu-923127

  5 replies

  17 years ago

  By: SwePeso

• Temp table

  I have a table TEMP_TOOL1 and its columns are DESCRIPTION , ITEM1 , AMOUNT AND ITEM2. ITEM1 AM…

  sampathsoft

  3 replies

  17 years ago

  By: sampathsoft

• 2 sets of count on the same field

  I am trying to perform a Count on the same field to spilt the data up into two sets, Tests and Sess…

  cindy_sinath

  3 replies

  17 years ago

  By: cindy_sinath

• Select stmt - no data brought back and there are records to output.

  I am using this code to produce a report of all appointments for tests on a given day for an instru…

  cindy_sinath

  3 replies

  17 years ago

  By: Gail Shaw

• passing parameters on a form - sql - to generate a report

  I am trying to generate a report from the output of the sql below but passing the staff ID and the …

  cindy_sinath

  3 replies

  17 years ago

  By: Jeffrey Williams

• Not part of an aggregate function

  I am trying to get the count of the total tests and sessions showing the description of the test an…

  cindy_sinath

  1 replies

  17 years ago

  By: RBarryYoung

• Retrieve variable value from dynamically concatenated variable

  Hello, I'm using dynamic sql to create cursors. Here is what I am trying to do: I want to concate…

  Jason Hanson

  17 replies

  17 years ago

  By: RBarryYoung

• This code should not work!

  Hello, As I was working on upgrading a SQL 2000 database to 2008, I came across something very stra…

  beaglez

  2 replies

  17 years ago

  By: beaglez

• Syntax Error on Join Operation

  I am trying to produce the total number of test for 2 types of test and sessions for October. I kee…

  cindy_sinath

  4 replies

  17 years ago

  By: cindy_sinath

• SELECT WHERE NOT IN query

  This isn't a problem anymore (it almost was, I was 90% of the way done with a forum post when I fig…

  Garadin

  7 replies

  17 years ago

  By: Garadin