T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• "Arithmetic overflow error converting varchar to data type numeric" message when field is decimal

  I am trying to setup an indicator value for an SSRS report to show green and red values on a report…

  miles_lesperance

  1 replies

  11 years, 11 months ago

  By: miles_lesperance

• Order by tweak

  Hello Please help me, i have a table with 500k rows, need to split into 3 sets(please assume need t…

  asita

  7 replies

  11 years, 11 months ago

  By: asita

• Convert Float to a Phone Number

  Hello Everyone I seem to always get the "Fun Stuff" to try and figure out. I have an entire table t…

  AndrewSQLDBA

  2 replies

  11 years, 11 months ago

  By: AndrewSQLDBA

• Select the Minimum Date from a Related Table

  Hello Everyone I am working on a query that seems very simple, but I just cannot seem to get it cor…

  AndrewSQLDBA

  4 replies

  11 years, 11 months ago

  By: LinksUp

• How do I select all or multiple rows from a typed xml variable?

  I am using xml schema that is like this: <DetailRows> <DetailRow> <MonthNumber…

  rehman-615909

  1 replies

  11 years, 11 months ago

  By: Eirikur Eiriksson

• selecting top 1 from multiple ranges...

  So I have data like the following: ID COUNTER DATA 1 10 BLAH 1 20 …

  Eric Stout

  6 replies

  11 years, 11 months ago

  By: Eric Stout

• sp_send_dbmail has formatting off on datetime when directing output to csv file

  I am running this sql which creates a csv file and sends the output via email. One of the columns …

  Patti Johnson

  7 replies

  11 years, 11 months ago

  By: Patti Johnson

• group columns to one row

  I have a table with the following columns Num,ID,Pos,Value 74 ,1,2,beck 74 ,1,2,greg 74 ,1,9,mike 7…

  demin99

  4 replies

  11 years, 11 months ago

  By: demin99

• Need help with runaway query using multiple APPLY joins

  I’ve never written a query with multiple APPLY joins before and I’m running into some troubles with…

  bncaffey

  10 replies

  11 years, 12 months ago

  By: ChrisM@Work

• How efficiently delete the old data?

  How efficiently delete old data for purging older than last 5 years data Selected and verified last…

  SQL Galaxy

  4 replies

  11 years, 12 months ago

  By: Jeff Moden

• Most Updated Records from Multiple Join Query

  Hi All, Suppose i have Two tables... with both the table having LastUpdated Column. And, in my Sel…

  Mr. Kapsicum

  5 replies

  11 years, 12 months ago

  By: Lynn Pettis

• Sql help

  Table is setup like this. My job is figure out all the item/records before it exceeds to some thres…

  SQL_Surfer

  3 replies

  11 years, 12 months ago

  By: Lynn Pettis

• Finding rows where user has access to contents but not record!

  Hi All, I'm got a "folder" structure application which we'll be using as an in-house directory view…

  kevinp81

  1 replies

  11 years, 12 months ago

  By: mcx5000

• Can value of parameters passed to a query be determined in Profiler

  In Profiler a StmtCompleted Event Class has identified a query to be: SELECT TOP 1 * FROM [WINSVR20…

  mpdillon

  5 replies

  11 years, 12 months ago

  By: Grant Fritchey

• Find all the rows from all tables in a DB for a specific column

  Hello, First of all, I couldn't find any existing thread talking of my "problem", based on my searc…

  franck.maton

  2 replies

  11 years, 12 months ago

  By: franck.maton