T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Split string to array

  Hi, can anyone give me a hand ? I have tried lot of methods but all failed :crying: below is the da…

  sqlbaby2

  4 replies

  15 years, 1 months ago

  By: sqlbaby2

• 2 SELECT statements from one CTE

  Hi, Can I have two select statements for one CTE. something like this: declare @counter int; with …

  sql_learner29

  23 replies

  15 years, 1 months ago

  By: SQLRNNR

• Discarding records whith date gaps

  I have read the post regarding identifying gaps in dates but it hasn't helped me come up with a sol…

  jwmott

  16 replies

  15 years, 1 months ago

  By: jwmott

• testing value of a subquery in the SELECT clause

  I have a query that looks like this (this is a simplified version of the query): select id, …

  buddy__a

  4 replies

  15 years, 1 months ago

  By: John Rowan

• Limit on number of savepoints in a transaction

  My question is --- is there a limit on number of savepoints that can be created in a single transac…

  sadana_vishal

  1 replies

  15 years, 1 months ago

  By: Adiga

• Query does not return data

  SELECT * FROM ABCD where ColA like '%AB CD EF GH%' or ColA like DE FD FG GH%' and Writt…

  mtz676

  5 replies

  15 years, 1 months ago

  By: Gail Shaw

• sp_MSForEachdb syntax error

  I need to execute the following script againts each database on a server to capture all the sql use…

  LOOKUP_BI-756009

  6 replies

  15 years, 1 months ago

  By: WayneS

• Looping and XML

  I've attached two text files. One containing XML that resides in a field in a SQL table, the other…

  cmayeux

  5 replies

  15 years, 1 months ago

  By: WayneS

• Service Broker Confusion

  I have a queue set up as follows: CREATE QUEUE [dbo].[SBWorkQueue] WITH STATUS = ON , RETENTIO…

  SwedishOrr

  4 replies

  15 years, 1 months ago

  By: SwedishOrr

• Parsing XML into a table

  I need to run a sql statement to produce NAMEVALUE addr120 Morris Ave addr2NULL or ‘’ addr3…

  Bill Maners

  4 replies

  15 years, 1 months ago

  By: Bill Maners

• Stored procedure output cached in cursor?

  We have a stored procedure that runs when an address is updated. The SP has 4 output variables - ar…

  KubaB

  4 replies

  15 years, 1 months ago

  By: KubaB

• Time Difference in Minutes

  How do i calculate the time difference in minutes between these two columns? Is it as....? SELECT D…

  akhlaq768

  2 replies

  15 years, 1 months ago

  By: akhlaq768

• what is sql_latin1_general_cp1_ci_as

  sql_latin1_general_cp1_ci_as

  rak_sql

  1 replies

  15 years, 1 months ago

  By: Suresh B.

• One-to-Many TSQL Query

  I have billing customers which has multiple shipping addresses. Unfortunately, we did a poor job of…

  rian67

  3 replies

  15 years, 1 months ago

  By: Andreas Goldman

• rounding error?

  I have this code that calculates a percentage: SELECT (100 / CAST(a.MonthPop AS decimal(10, 2))…

  whitlander

  4 replies

  15 years, 1 months ago

  By: Carl Federl