T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• please help me.. while loop

  i have a table test field1 int pk field2 int field_encrypt varbinary(256) not null initial inserted…

  venkatesh.kuppili

  8 replies

  17 years ago

  By: Jeff Moden

• Length of Data Type

  I am trying to write a stored procedure to return metadata about a given stored procedure. I have f…

  Goldie Lesser

  2 replies

  17 years ago

  By: Goldie Lesser

• Breakdown IP Addresses

  Does anyone have a way to breakdown an IP address to the numbers in separate fields no matter how m…

  Matthew J Luckhaupt

  1 replies

  17 years ago

  By: Lowell

• Return Average build cost based on last 5 Orders

  Hi. Where to begin....I need to arrive at an average build cost for a Product taking into account a…

  2Tall

  29 replies

  17 years ago

  By: 2Tall

• IS OPENROWSET the only way to query an SPs recordset?

  I would like to "Select * from" the recordset output of a Stored procedure. Here's an example of th…

  Takauma

  2 replies

  17 years ago

  By: Matt Miller (4)

• Get count of each ID in query

  I have a query that writes out 2 columns and one of those columns is called "dataID". An example ou…

  Magy

  7 replies

  17 years ago

  By: Adil-746852

• re-sequencing an integer column

  I am working with a medical practice management database, trying to correct a problem with a single…

  kcd7216

  2 replies

  17 years ago

  By: kcd7216

• Appending nvarchar in a variable

  Hi folks, trying to do something new here: I'm trying to append the selected data of a select in a …

  J-F Bergeron

  2 replies

  17 years ago

  By: J-F Bergeron

• SELECT COUNT(*) on a view runs many times longer than SELECT * on same view

  Hello, I have a view which includes joins to a single table view and a single table subquery, and U…

  Matty Z

  1 replies

  17 years ago

  By: Grant Fritchey

• Would love some help in redefining a "process"

  We have an interesting dilemna that I need some help in redefining. We have a table named ptDemogra…

  MrBaseball34

  8 replies

  17 years ago

  By: MrBaseball34

• I want to get Distinct Values From Table

  Hi All, My Query returns onecolumn consider, Column1 -------- Value1, Value2 Value1, Value3 Value1,…

  santoooo

  15 replies

  17 years ago

  By: RBarryYoung

• Selecting random

  Hi all. Can anyone tell me if its possible to select 4 random rows from a table? Many thanks.

  gavin.duncan-770062

  8 replies

  17 years ago

  By: Ray M

• Transposing and capitalising col

  I have a table which contains a column of name data in the format of:- DAVIDSON P E FORBES GE G…

  louise-791468

  2 replies

  17 years ago

  By: Ray M

• Arithmetic overflow when CASTing to decimal

  This isn't urgent, because I addressed the problem. What I'm curious about is why this has to be do…

  Matt Cherwin

  3 replies

  17 years ago

  By: Garadin

• Update query won't update

  Hello everyone, I can get this to run no problem, but it always says "0 records updated". I'm prett…

  betsy.powlen

  8 replies

  17 years ago

  By: betsy.powlen