T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• SQL to extract Data from XML string stored in nvarchar column

  Hi, I have a column with datatype nvarchar where we are storing XML string, e.g below <?xml vers…

  pujain

  1 replies

  11 years, 1 month ago

  By: Phil Parkin

• How to use begin try and transaction with in a loop which call other stored procs.

  Dear ALL I have to call few strored precedure like sp1 sp2 sp3 from spmain. Spmain will be schedule…

  rajemessage 14195

  7 replies

  11 years, 2 months ago

  By: Lynn Pettis

• Adding Where Condition on Select query on a View : Error converting data type varchar to bigint.

  Hi, I am building a View with an integer column by filtering data from Master table and below is th…

  ykmohank-911030

  2 replies

  11 years, 2 months ago

  By: ykmohank-911030

• Reading match pair of descandats of XML elements in xquiry through T-Sql

  In the following XML <Recordset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> &…

  danyc

  2 replies

  11 years, 2 months ago

  By: danyc

• Insert Statement for 2 million rows

  Hi! I have multiple (individual) insert statement to insert around 2 million rows (using sqlcmd bec…

  PJ_SQL

  7 replies

  11 years, 2 months ago

  By: PJ_SQL

• Converting Quartz.Net time columns to datetime

  My company has a product that utilizes the Quartz.Net[/url] scheduling library. It is using SQL Se…

  Jedak

  10 replies

  11 years, 2 months ago

  By: Jedak

• Creating a ROT13 Function

  I'm trying to create a ROT13 function without having to use the xp_rot13 So I've got this SELECT T…

  mtassin

  14 replies

  11 years, 2 months ago

  By: mtassin

• Server-Friendly Way To Do Big String Search?

  I am working on a project for a company that offers online continuing education classes. The course…

  autoexcrement

  4 replies

  11 years, 2 months ago

  By: autoexcrement

• Windowed Function in Where Clause

  So, as far as I know (and as I've just been attempting to prove to a member of my client's staff),…

  irobertson

  7 replies

  11 years, 2 months ago

  By: ChrisM@Work

• Convert consecutive rows with a date to date range

  OK this is more of an academic question but having looked all over I haven't been able to find a so…

  d viz

  8 replies

  11 years, 2 months ago

  By: Dwain Camps

• Remove duplicates from Multiple colums please help me

  Input: Table1 D1 D2 D3 D4 D5 1 4 4 2 3 Excepted output Table2 D1 D2 D3 D4 D5 1 4 2 3 I …

  Ayishwaryalakshmi.M

  1 replies

  11 years, 2 months ago

  By: Dwain Camps

• OPENROWSET XML from an Execution Plan causes encoding error

  Hello all, I can't believe this isn't working. I've got incredibly simple code. But I'm missing som…

  Grant Fritchey

  3 replies

  11 years, 2 months ago

  By: Grant Fritchey

• Floor(), strings, a precision limits

  It seems SQLServer draws a line at a given precision (I guess it's 16) for the floor() function whe…

  SJTerrill

  2 replies

  11 years, 2 months ago

  By: SJTerrill

• Help with writing case statement in a Query

  Hi All, I have got couple of tables and parameters each. #test #test1 @Extract @Desc Now based on t…

  Chinna

  4 replies

  11 years, 2 months ago

  By: Dwain Camps

• Finding hierarchy errors

  Hi all, I've read some posts by Jeff Moden and Gsquared on Hierarchy structures (very helpfull, tha…

  Cees Cappelle-442904

  9 replies

  11 years, 2 months ago

  By: Cees Cappelle-442904