T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Query Causing Blocking....Need Help Please---Urgent

  set nocount on print 'Show Size, Space Used, Unused Space, Type, and Name of all database files' se…

  sqlquest2575

  3 replies

  13 years, 9 months ago

  By: sqlquest2575

• using query optimiser option hints in UDF (User Defined Function)

  Hi guys. Using SQL2000....... I have a UDF that takes a single parameter (integer) returns a scalar…

  aaron.reese

  4 replies

  13 years, 9 months ago

  By: drew.allen

• Need help getting the product of two sub queries Can Someone Help?

  My problem is as follows. I have this query that works fine as two seperate subquery fields. --V…

  gregory.perry2

  6 replies

  13 years, 9 months ago

  By: gregory.perry2 87972

• Nested FOR XML with namespaces

  I have the following example query: DECLARE @foo TABLE(value INT); DECLARE @bar TABLE(foo INT, val…

  weitzera

  1 replies

  13 years, 10 months ago

  By: weitzera

• Turn integer into time of day

  I am sad to say I haven't been able to figure this out. I have a table with a Start Time and an End…

  baileyc411

  6 replies

  13 years, 10 months ago

  By: baileyc411

• Data type for storing script files

  HI , I want store some script files in my table . Which data type i have to use to store script f…

  Lavanyasri

  3 replies

  13 years, 10 months ago

  By: Eugene Elutin

• Declare statement inside cursor

  Create Table #Table (id int,Empname varchar(10),Job varchar(10)) Insert into #Table values (1,'shar…

  sharath.chalamgari

  8 replies

  13 years, 10 months ago

  By: Eugene Elutin

• Returning row count as output in CTE

  I'm doing something similar to the below example: DECLARE @RowStart INT DECLARE @RowEnd INT SET @R…

  brendan woulfe

  16 replies

  13 years, 10 months ago

  By: ChrisM@Work

• nothing returning for date

  Hi can someone tell me this doesn;t work?? It just returns a blank every time. The same happens whe…

  spin

  16 replies

  13 years, 10 months ago

  By: Jeff Moden

• Help Doing A Comparison Calculation With Current Date

  Hello All! My stored procedure works to calculate total number of days of Holidays taken eliminati…

  staindshady_03

  5 replies

  13 years, 10 months ago

  By: staindshady_03

• open query rolling dates

  hi i'm querying against a linked db (unix) and am trying to create a between predicate for current…

  spin

  5 replies

  13 years, 10 months ago

  By: Phil Parkin

• Creating nested xml tree

  I'm trying to create a xml tree by writing a sql query. Here is what I have: DECLARE @CountOfPort…

  rs80

  20 replies

  13 years, 10 months ago

  By: Matt Miller (4)

• Using Variables increases Scans and Logical Reads

  I can't understand this. I have a query and if I hard code a number for a EntityType in the query,…

  Mike Is Here

  4 replies

  13 years, 10 months ago

  By: ChrisTaylor

• multiply aggregate

  hi i have three rows in a table for each product. each line represent a different unit of measure v…

  spin

  6 replies

  13 years, 10 months ago

  By: spin

• Joining with Nulls

  I hate asking questions when I know there are 42,000 answers out there already, but I can't seem to…

  james.massey

  4 replies

  13 years, 10 months ago

  By: james.massey