T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Updaing using ROW_NUMBER()

  Let's just say I have a table with columns ID and Name that looks like: [font="Courier New"]ID …

  SALIM ALI

  2 replies

  12 years, 2 months ago

  By: SALIM ALI

• TSql XML Column modification error with XSD using replace value of

  Good day, The following test is working: DECLARE @XmlTest TABLE ( ID int, MyContent Xml ) decla…

  denis.gilbert

  1 replies

  12 years, 2 months ago

  By: denis.gilbert

• Flatten a one to many?

  Hello all. I’ve got an issue with flattening a 1 to many relationship. For argument’s sake, let…

  kpwimberger

  12 replies

  12 years, 2 months ago

  By: kpwimberger

• cursor concatenating variable

  hi all i'm writing a cursor to send emails when our stock level goes below a safety value. The curs…

  spin

  8 replies

  12 years, 2 months ago

  By: Sean Lange

• Query to find items purchased from multiple vendors

  Hi All, I want to find item that purchased from more than one supplier, so i am running following q…

  neellotus07

  3 replies

  12 years, 2 months ago

  By: David Burrows

• Cursor.. cmds don’t seem to update until everything has finished

  I have a cursor and in that cursor I have a number of commands like EXEC (@command) print 'ghgfhgfh…

  Edward-445599

  3 replies

  12 years, 2 months ago

  By: Sean Lange

• Exec sql stored Proc from vb

  Hi all Im trying to execute a stored procedure that doesn't return any value, from vb, and it does…

  sweniosSqlSeeker

  2 replies

  12 years, 2 months ago

  By: sweniosSqlSeeker

• Fuzzy lookup on multiple columns

  I have a problem where i would need to do a fuzzy lookup on the below columns and get the possible …

  mmswamy

  1 replies

  12 years, 2 months ago

  By: Orlando Colamatteo

• In a Jam - Need Some Help

  Hello, I'm urgently working away at this but not able to solve my problem. I'm at the point of nee…

  Polymorphist

  3 replies

  12 years, 2 months ago

  By: Your Name Here

• Calculate an expression

  Hello, I need help to calculate an expression in sql. For example I have to send (248/5)*30 to a st…

  sistemas_casinomnes

  2 replies

  12 years, 2 months ago

  By: Phil Parkin

• Delete column from multiple (hundreds) of tables

  Hi, I have a rather large number of tables made using a (fairly) standard template. Due to a compat…

  sqldriver

  4 replies

  12 years, 2 months ago

  By: Dwain Camps

• Two tables and want to join on different columns

  I want to join two tables order_ship and ship_id. I want to join on location and order_no which bot…

  twdavis-893252

  1 replies

  12 years, 2 months ago

  By: RP_DBA

• Maintenance Plan Question

  I have a extremely time consuming query that times out whenever it runs. To cure the issue, I creat…

  kabaari

  4 replies

  12 years, 2 months ago

  By: Michael L John

• I Think This Join Statement is Making Me Crazy(er)

  I feel like I've been staring at this statement for hours and just keep mangling it more. Any help…

  mkswanson

  7 replies

  12 years, 2 months ago

  By: mkswanson

• Slow Update Processing - Badly Written Code ?

  I'm at a new place, trying to find my way around. There's an import/update process that runs very s…

  homebrew01

  2 replies

  12 years, 2 months ago

  By: homebrew01