T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Best approach for Data transfer of large number of rows

  Hello, we have our database in sql 2005 version Enterprise Edition . Because of performance issue w…

  Megha P

  8 replies

  11 years, 2 months ago

  By: Koen Verbeeck

• Update Where

  Hi All, I have two tables users and usersproperties, users has all the users basic details and user…

  ringovski

  1 replies

  11 years, 2 months ago

  By: Umer Akram

• Parsing XML Blob

  I am having problem trying to parse an XML field in a table because it is too complex for me. I nee…

  elfresco1

  5 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• Concatenate varchar and int fields which allows null

  I have four fields: FirstName varchar(20),null MiddleName varchar(5),null LastName varchar(30),null…

  PJ_SQL

  1 replies

  11 years, 2 months ago

  By: Sean Lange

• How to find N Consecutive records in a table

  Hi, I have the following Table definition with sample data. In the following table, Customer Produc…

  leo4Ever

  9 replies

  11 years, 2 months ago

  By: e-ghetto

• sql dynaminc and aggregate functions

  Hi, Just looking if somebody has experienced, i have written a tql code query something like, and r…

  Lou

  4 replies

  11 years, 2 months ago

  By: Lou

• batch max date top

  Hi, I'm requesting for your help, trying to fix this query Please give me your advice: create table…

  Lou

  3 replies

  11 years, 2 months ago

  By: Luis Cazares

• SQL date with year & Quater

  I have a table with five columns as ID Join_Date Join_Qtr End_Date End_Qtr 1 2014-01-12 2…

  kishorreddy.yuva

  1 replies

  11 years, 2 months ago

  By: Sean Lange

• select with single quotes

  I have a table A with 1 column Table A ColA 121 3423 4564 5435 63 76 8989 How can I write a select …

  mtz676

  11 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• Is it possible to return a default value if one record return null

  Hi, I am new in SQL. Now I want to handle the case that if I am selecting for the Name and Unit in …

  crayon_kiss

  1 replies

  11 years, 2 months ago

  By: free_mascot

• Multiple updates in 1 table from another table

  I have Table A with 20000 rows and I need to update column B values in Table A from Table B's Col C…

  mtz676

  3 replies

  11 years, 2 months ago

  By: mtz676

• How to Delete Right 3 Characters from a string

  Hi, I am trying to delete 3 characters from the right in a column. I can't find a function that wi…

  //Ravi

  26 replies

  11 years, 2 months ago

  By: sharonsql2013

• Ordering items by hierarchy without RBAR

  Hey all, I feel like I already know the answer to this question, but it is eluding me ... Say I hav…

  kramaswamy

  1 replies

  11 years, 2 months ago

  By: Jeff Moden

• Running SSIS package with other domain account

  Hi , I have a ssis package(2008r2) in production server(file system) and multiple users have login…

  mahesh.yerragonda

  8 replies

  11 years, 2 months ago

  By: Koen Verbeeck

• Is it possible to use a parameter for csv values

  I have a query ending with WHERE MyID IN (12, 14, 18) and want to replace it by a parameter like WH…

  Henk Schreij

  6 replies

  11 years, 2 months ago

  By: Ed Wagner