T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Subquery returns more than 1 record in table UPDATE

  Hi, I need to update temporary table ‘@tmpOutput’ using a reference table ‘Haulage_Rate’. Table ‘@t…

  DerbyNeal

  3 replies

  13 years, 6 months ago

  By: DerbyNeal

• substring with charindex --Invalid length parameter passed to the substring function. Or conversion failed when converting varchar value to int.

  Hi All, I keep getting these error messages. Invalid length parameter passed to the substring funct…

  RZebra

  2 replies

  13 years, 6 months ago

  By: RZebra

• Why does the same code yield different results running in T-SQL interactively vs. as a TVF?

  I've created a simple TVF (based on Jeff Moden's posts) to shred delimited strings to their constit…

  Rich Mechaber

  11 replies

  13 years, 6 months ago

  By: Jeff Moden

• Issue with View

  I have 2 tables employee and employee_address CREATE TABLE employee ( employee_code varchar(10), …

  Ajit-297150

  6 replies

  13 years, 6 months ago

  By: matzer

• Order Function Returned Table

  Hi, here is the problem /* Order Function Returned Table * Need to minimaly change a function(GetB…

  RMiranda

  1 replies

  13 years, 6 months ago

  By: Lynn Pettis

• Can someone tell me how to write this query? Thanks

  Good day, I have a table with a timestamp for each record, I have a need to select the records base…

  halifaxdal

  9 replies

  13 years, 6 months ago

  By: halifaxdal

• total inside cte

  declare @hierarchy table(id int,name nvarchar(40),parentid int,cost int) insert into @hierarchy sel…

  sayedkhalid99

  10 replies

  13 years, 6 months ago

  By: Jeff Moden

• Get Data from XML Nodes for multiple rows

  I apologize in advance if you see this posted in two spots. I believe i posted this in a dead threa…

  pricejt

  3 replies

  13 years, 6 months ago

  By: Jeff Moden

• Transpose rows to columns

  Hi, I have the follwoing seperate queries that I need wrapped up into one row per order with speera…

  ashley 28726

  1 replies

  13 years, 6 months ago

  By: Jack Corbett

• Replace CASE with PIVOT

  Dear SQL Experts, I have a lot of code that uses CASE Statements. I'm trying to wean myself off of …

  Welsh Corgi

  2 replies

  13 years, 6 months ago

  By: Welsh Corgi

• Calculating Percentage using a CTE Or with a COUNT(*) OVER Clause

  How can I get the percentage Quotes that became a Sale using a CTE? SELECT TOP 5 [Marketing Rep], …

  Welsh Corgi

  8 replies

  13 years, 6 months ago

  By: Welsh Corgi

• need a merge workaround

  I need to change a loading proc and i was going to use the merge. Turns out the merge statement is …

  Snargables

  1 replies

  13 years, 6 months ago

  By: GSquared

• I can't execute "use @database" in cursor

  I need to solve the problem to execute sp_addextendedproperty with a new description for a column b…

  angeldomon

  5 replies

  13 years, 6 months ago

  By: shaunfox

• Split string into multiple columns

  Hi guys, I have a string "1|HK$ 500 (Gift voucher)|500|2,1|HK$ 1000 (Gift voucher)|1000|2" I want t…

  Sagar Sawant

  2 replies

  13 years, 6 months ago

  By: Cadavre

• Two databases - same instance - query both

  I have 2 databases.......NBXWEB and RBI......I wrote this select statement....which is my first att…

  Bron Tamulis

  6 replies

  13 years, 6 months ago

  By: Jason Selburg