T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Dynamic Tablename within stored procedure HELP PLS

  Hi all. First of all, i am relatively unexperienced with tsql, so please do not judge too hard if m…

  joerg 22560

  3 replies

  13 years, 4 months ago

  By: joerg 22560

• Nesting Dateadd funtion

  I am querying a database with values recorded every 15 minutes. But its not exactly every 15 minute…

  michael.reining

  3 replies

  13 years, 4 months ago

  By: michael.reining

• Update Query Help

  Hello All, First, this is my first posting to a forum like this so I apologize in advance if I am …

  SQL2005NEWB

  1 replies

  13 years, 4 months ago

  By: Grant Fritchey

• TSQL 2005 XML Explicit - CDATA is padded with leading and trailing space?

  Hi, if I use 'Element' I get <item>bob</item> But, if I use CDATA as I need to, I get &…

  andy.welch

  1 replies

  13 years, 4 months ago

  By: andy.welch

• Help with a query.

  Hi All, i have this data: DECLARE @data table (n INT) INSERT @data SELECT 1 UNION ALL SELECT 10 UN…

  xRafo

  16 replies

  13 years, 4 months ago

  By: Jeff Moden

• Return user only if all rows match

  I have a table with the user, username, a table with questions and a table users' answers Let's say…

  TcW_1978

  3 replies

  13 years, 4 months ago

  By: TcW_1978

• Person data- Multiple rows due to more than 1 name. Automatic Numbering of rows

  I have the following script DROP TABLE dbo.SOC_CARE_DATA_QUALITY_EXTRACT_ALIAS_DUPS_ONLY CREATE TAB…

  Debbie Edwards

  14 replies

  13 years, 4 months ago

  By: fahey.jonathan

• Help finding all possible combinations within a group of data

  Good morning! I have a sample table of data, here is what I am trying to accomplish.... I need to k…

  mmiller 85218

  34 replies

  13 years, 4 months ago

  By: Mark Cowne

• Splitting a column in two by bytes

  I have a need to split an Address into to two columns based on the middle point of the columns byte…

  TeraByteMe

  3 replies

  13 years, 4 months ago

  By: TeraByteMe

• Upgrading from 2000

  Hello, We're about to upgrade from 2000 to 2005. Yep we're a little behind but not our fault, haha.…

  Ken at work

  11 replies

  13 years, 4 months ago

  By: Ken at work

• How to get store procedure informations

  Hi all, i have alot of store procedures ...i have written discription etc for each while creating s…

  MuhammadShafiq

  5 replies

  13 years, 4 months ago

  By: MuhammadShafiq

• table valued functions store temp tbl

  Hi, Need some help in below requirement. I have a table called Emp. CREATE TABLE [dbo].[Emp]( [Emp…

  Oracle_91

  2 replies

  13 years, 4 months ago

  By: Oracle_91

• T-SQL Dynamic Stored procedure for SQL2K5 Errors again!

  Hi Guys, Any idea why the following code produces the following errors and any ways I can fix them?…

  jon.hall 50545

  25 replies

  13 years, 4 months ago

  By: jcb

• How can i see if a proc call is using a cached execution plan?

  How can i see if a proc call is using a cached execution plan?

  Snargables

  1 replies

  13 years, 4 months ago

  By: Grant Fritchey

• Datetime Ceiling Function. Rounding Dates and Times Up

  Hello all, I've got a bit of a weird situation with the statistics generated by the software of one…

  clubbavich

  6 replies

  13 years, 4 months ago

  By: clubbavich