T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Help With getting a count query to work

  I am trying to create a query that will count the number of incidents in a table. When I create th…

  ppierce10

  5 replies

  16 years, 6 months ago

  By: BaldingLoopMan

• Collate command in a T-SQL selection

  DECLARE @sql AS VARCHAR(MAX) SET @sql = 'SELECT SRequest.SRequestId FROM dbo.vw_SRequest SRequest…

  mark.veitch

  7 replies

  16 years, 6 months ago

  By: NicHopper

• How can I get list of deleted records in Trigger ?

  I write an INSTEAD OF Trigger to do something before real deleting. e.g. TableA has ID which is Pri…

  neo_pom

  2 replies

  16 years, 6 months ago

  By: neo_pom

• Merging values

  Hi, I have two tables, on the basis of rules defined in one table i have to insert values into othe…

  Anamika

  2 replies

  16 years, 6 months ago

  By: Anamika

• Conversion failure with stored procedure?

  Hi There, I am having some issues with my cursor/stored procedure/function. I run a cursor to take…

  cpicard

  6 replies

  16 years, 6 months ago

  By: Jeff Moden

• Prefixing with the from table with a variable that contains linked server info

  After some wise words of wisdom ... Ive got this so far .... declare @linkedservervarchar(100), …

  Simon_L

  8 replies

  16 years, 6 months ago

  By: The Dixie Flatline

• Reading CSV file a line at a time using uftReadfileAsTable

  Hi, I have CSV files which I'd like to load into a table using the function uftReadfileAsTable. (h…

  smithsp17

  9 replies

  16 years, 6 months ago

  By: smithsp17

• Building Date Comparison String

  I'm trying to build a proc where I will use a datetime variable called @PaidThruRun in the Where cl…

  Roger Abram

  10 replies

  16 years, 6 months ago

  By: Lynn Pettis

• select from table variable

  Hi, Steps in my sp goes like this:- declare @mytable table (a int, b int, c int); insert into @myta…

  sanya.ibrahim

  9 replies

  16 years, 6 months ago

  By: The Dixie Flatline

• Cannot reference field from derived query in FROM clause, in derived query in JOIN clause?

  I'm trying to optimize a top 50 accounts receivable report. Currently the report makes 51 calls to …

  tnk

  10 replies

  16 years, 6 months ago

  By: SQLRNNR

• storing url of an image in sql server 2005 table

  How to store the url of an image using insert statement in sql server 2005? What is the syntax?

  crprajan

  2 replies

  16 years, 6 months ago

  By: knausk

• Convert searched String to number

  Hi I have a database that stores information for all printers connected to our Corporate Network. I…

  andy.woodward

  12 replies

  16 years, 6 months ago

  By: Jeff Moden

• Need help verifying trigger functionality

  Hi all - before I implement this trigger I'd like some review to ensure this is doing what I want i…

  kramaswamy

  4 replies

  16 years, 6 months ago

  By: kramaswamy

• second insert trigger in same table?

  Is it possible to have a second insert trigger (ie I all ready have one insert trigger that monitor…

  Sailor

  3 replies

  16 years, 6 months ago

  By: Jack Corbett

• Left join would not work with a "where" clause

  Hi, I have a query to check if any of the databases on the reporting server did not restore. I hav…

  Roust_m

  17 replies

  16 years, 6 months ago

  By: Saurabh Dwivedy