T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Grouping

  Hi, This isn't a re-post. Same query but different question - SELECT --E.AuditKey, --can't use new…

  krypto69

  7 replies

  13 years ago

  By: krypto69

• SProc Structure - Encapsulate into one procedure, or split out into separate sprocs?

  Just wondering peoples opinion on this, and your take on the pros vs cons of each scenario. I was r…

  RossRoss

  5 replies

  13 years ago

  By: Orlando Colamatteo

• Help with terminated employee count Query

  I have this HR query that I'm having some trouble with. It is used to pull the count of number of t…

  krypto69

  3 replies

  13 years ago

  By: krypto69

• Update Recursively

  Hi, I have a hierarchical data in my database, such as: id_task|id_parent|value 1 | NULL …

  denisribeiro

  6 replies

  13 years ago

  By: Jeff Moden

• Ascii code spaces

  Hi we are experiencing difficulties importing data into sql. We are handling data from an excel fil…

  jvElecenter

  4 replies

  13 years ago

  By: guillermoolmo

• can we compress any file throgh SQL Server

  Hi, Can we compress any file throgh SQL Server - using bcp, xp_cmdshell? - using sql_cmd? …

  phani31

  2 replies

  13 years ago

  By: phani31

• Pulling Data out of a Cube

  I have never worked with MS Analysis Services Database.. but I have been asked to pull some data ou…

  dwilliscp

  3 replies

  13 years ago

  By: drew.allen

• converting milliseconds

  Hi, how to convert milliseconds into hours,minutes,seconds and milliseconds. i have two dates from …

  ramu4ind

  12 replies

  13 years ago

  By: scotty b

• Selecting "All" records where "All" is actually only partial records

  I have a list which displays filter options for the user, based on settings for that user. So the t…

  OceanDiscovery

  7 replies

  13 years ago

  By: OceanDiscovery

• Frustration with FOR XML

  I'm reaching the end of my rope with this project, I'm really hoping someone can help me. I'm task…

  ronmoses@gmail.com

  7 replies

  13 years ago

  By: ronmoses@gmail.com

• Passing Parameter with a wildcard

  Background:I am running queries against pre-2005 databases. I'm trying to normalize data from a tab…

  themangoagent

  27 replies

  13 years ago

  By: drew.allen

• Upgrading Sql From 2005 To 2008

  I have my complete database in sqlserver2005. All Is running well.There are a lot of Stored Procedu…

  MuhammadShafiq

  2 replies

  13 years ago

  By: MuhammadShafiq

• Pass Database name in SP

  I am creating sp where I need to pass tablename and database name in order to query INFORMATION_SCH…

  borislava99

  4 replies

  13 years ago

  By: Orlando Colamatteo

• Multiple Resultsets in Excel via VBA

  Sql Server 2005 /Excel 2003 I tried returning top & bottom results & then importing all 4…

  ackrite55

  5 replies

  13 years ago

  By: graham.stent

• XML Question

  Hello all, I'm having some trouble selecting out some values from an XML column. I believe my issu…

  Ruprecht

  3 replies

  13 years ago

  By: seth delconte