T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• formatted xml with 'for xml'

  Dear All, my query is below which is working fine WITH tempPagedag AS ( SELECT *, ROW_NUMBER() OVER…

  zeeshan asghar

  1 replies

  14 years, 5 months ago

  By: drew.allen

• Need T-SQL help aggregating like records resulting with start date and end date

  I am working with a feed of employee data that is updated daily. I intend to use T-SQL to aggregate…

  gary.proctor

  10 replies

  14 years, 5 months ago

  By: Mark Cowne

• Urgent..........How to import Excel having Multiple Sheet

  Hi I wants to import Excel having Multiple Sheet using Excel Source in SSIS package in to a single …

  Anoop Saxena

  7 replies

  14 years, 5 months ago

  By: bhsim

• COMPUTE clause #1, aggregate expression #1 is not in the select list.

  Newbie at the wheel... Taking this table.. create table test ( color_names varchar(20) ) insert …

  J M-314995

  3 replies

  14 years, 5 months ago

  By: drew.allen

• List all indexes on an instance

  This has been killing me... I have been searching for a good script to show all indexes on an insta…

  kingrudedog

  9 replies

  14 years, 5 months ago

  By: kingrudedog

• Why can I not use a len() in a substring? When I run this, it always returns the column length of 255

  use master; declare @x int select @x=len(physical_name) from sys.database_files select 'move' ,'…

  jerome.landis

  14 replies

  14 years, 5 months ago

  By: Jeffrey Williams

• After insert/update/delete timing

  Hi Experts, I've got a "trivial" task to log changes made by various applications to two related ta…

  denis.p

  6 replies

  14 years, 5 months ago

  By: Orlando Colamatteo

• Pivot Table Help

  I have a table (SurverResults) with the following columns: id_num int ID of pe…

  mark.allen 70725

  2 replies

  14 years, 5 months ago

  By: mark.allen 70725

• loop through linked servers

  Hi I am running 10 cte select statement against 10 linked servers and combining the results with a …

  Marcus Farrugia

  3 replies

  14 years, 5 months ago

  By: kramaswamy

• Delete duplicate reocrds from Table based on the date sorting

  Hi, I have a table in the following format - Create Table myTable(ID Varchar(20),GUID Varchar(20),…

  AMJ-458987

  4 replies

  14 years, 5 months ago

  By: AMJ-458987

• Problem in Subtraction

  Hello! My issue is that my stored procedure only works if there is data in the table that it's refe…

  Rank1_nj

  2 replies

  14 years, 5 months ago

  By: kramaswamy

• SQL Script to DELETE FOLDERS?

  Hi - I need to create a sql script that will delete FOLDERS older than 2 days. Can anyone please p…

  dso808

  6 replies

  14 years, 5 months ago

  By: dso808

• How to pass LinkedServer Parameter to OpenQuery?

  Hi, how can I pass a parameter for the LinkedServer to an openquery? I am receiving the following …

  Marcus Farrugia

  2 replies

  14 years, 5 months ago

  By: SQLSrvrN00b

• Need to bring required result

  Hi, Below one is my sample Table Structure Declare @t table ( Series varchar(50), S1 varchar(5…

  KMPSSS

  1 replies

  14 years, 5 months ago

  By: tommyh

• CTE/View definition

  Hi How to change the view definition ? I have a table with all columns having not null values when…

  amit_adarsh

  3 replies

  14 years, 5 months ago

  By: steveb.