T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• openquery, dynamic SQL, Linked server (ADSI), GURU Required.

  Goal: To have a result set consisting of two columns DepartmentName, Computer Env: SQL Server 2005,…

  munta

  8 replies

  13 years, 5 months ago

  By: GSquared

• Find lower case field names

  Hi friends, I'm trying to rename column names that are in lower case to upper case in some tables.…

  newbieuser

  16 replies

  13 years, 5 months ago

  By: Jeff Moden

• illegal xml character - how to find the offending row

  Hello, I've been knocking my head against this one for a couple of hours. I'm getting this error: M…

  webrunner

  7 replies

  13 years, 5 months ago

  By: webrunner

• Save data from XLS,XLSX,CSV files to sqlserver2005

  Hi all, i am using jquery ajax and asp.net(C#) to save data from xls,xlsx,csv to sqlserver2005. OR …

  MuhammadShafiq

  15 replies

  13 years, 5 months ago

  By: GSquared

• Error changing a varchar column to allow nulls

  I have a table called Assessment that has a varchar column called AssessedWithParcel. I want to ch…

  clbast

  4 replies

  13 years, 6 months ago

  By: Gail Shaw

• Query with date ranges

  Hi folks, I need some help with a query, here is some testdata --available stores CREATE TABLE #st…

  shadow_2

  4 replies

  13 years, 6 months ago

  By: matzer

• recursive cte to count subfolders

  HI all, I have a requiremnent to count all the subfolders in the given root folder was trying to do…

  sql_learner29

  15 replies

  13 years, 6 months ago

  By: Sean Lange

• How to group based on value and rank

  Hello All I need some pointers on how to get started with a query. The problem is how to group some…

  philippe-546556

  6 replies

  13 years, 6 months ago

  By: philippe-546556

• SELECT statement - value gets truncated when selecting from XML column

  Hi, SQL 2005/2008. While retrieving data from xml column of a table and concatenating with a string…

  iBar

  11 replies

  13 years, 6 months ago

  By: GSquared

• Update Value in XML Node Joining From a Table

  I have an XML response string. I need to query a table and fetch Desc for Id 1 and replace it with …

  sivaram

  5 replies

  13 years, 6 months ago

  By: Matija Lah

• Save data from XLS,XLSX,CSV files to sqlserver2005

  HI all, i am using jquery and asp.net using C#.i want to save data from CSV,XLSX,XLS etc directely …

  MuhammadShafiq

  1 replies

  13 years, 6 months ago

  By: Devendrakumar

• dynamic email report

  Hi All, I've created a Top 20 report on customers by turnover which i'm emailing on the 1st of ever…

  spin

  4 replies

  13 years, 6 months ago

  By: Jason Selburg

• Update record getting from some SQL Query

  select [time] from citizenservice group by ctznid,[time] having count([time])=1 i want to update th…

  farhanfarooq82

  5 replies

  13 years, 6 months ago

  By: drew.allen

• Update @table with join

  Hi, I have two table variables with two fields each. The definitions are as below:- declare @DocDat…

  geo123abram

  2 replies

  13 years, 6 months ago

  By: geo123abram

• >=x versus IN

  Hi, Please could someone help me understand why query A below is a lot slower than query B A] selec…

  Ulysses_Infinity

  4 replies

  13 years, 6 months ago

  By: ChazMan