If for some reason you can't use a calendar table, you could do something like this: -

DECLARE @startDate DATE = '2012-07-05', @endDate DATE = '2012-07-26';

WITH t1(N) AS (SELECT N FROM...

See this article, which explains how to do it --> http://www.sqlservercentral.com/articles/Tally+Table/72993/%5B/url%5D.

Would this not achieve the same thing?

DECLARE @sql NVARCHAR(MAX), @SEARCH_STRING NVARCHAR(100) = '%TB_DIM%';

SELECT @sql = STUFF(sqlCode.value('.', 'varchar(max)'),1,10,'') + ';'

FROM (SELECT 'UNION ALL SELECT table_catalog + '+CHAR(39)+'.'+CHAR(39)+' + table_name ' +...

chaseurpuli (6/22/2012)

---

Thank you for your reply Cadavre. But, I am looking for something different.

I want only the characters to th left of the first occurance of any list of...

Is this what you're looking for?

--Sample data

SELECT Name

INTO Employees

FROM (VALUES('edwardneuman!"<]'),

('mikemoreno)''>$:'),

...

imex (6/20/2012)

---

Hi,

Try:

SELECT SUBSTRING(( SELECT ', ' + CAST(ID as varchar) + ' ' + Name

...

Check out Gail Shaw's blog post, she answers your question there --> http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

BEGIN TRAN

--Build sample data in TEST table

SELECT col1

INTO TEST

FROM (VALUES('STYLE'),('HK82382'),('HK82386'),

('HK84174'),('HK86190'),('HK87143'),

...

Why are you trying to count without count?

Take this table:

SET NOCOUNT ON;

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE #testEnvironment;

END;

SELECT TOP 1000000 IDENTITY(INT,1,1) AS ID,

REPLACE(CAST(NEWID() AS VARCHAR(36)),'-','...

Well, I doubt I'd be the developer I am today (or have the job I currently have) without Jeff and a lot of other people from this site (way too...

dwain.c (6/20/2012)

---

Nice one Cadavre!

That's the same collation issue that I was trying to address the other day when timing REPLACE on another thread.

Just one question though. Did Jeff Moden...

Shall we take a look at performance?

SET NOCOUNT ON;

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE #testEnvironment;

END;

SELECT TOP 1000000 IDENTITY(INT,1,1) AS ID,

REPLACE(CAST(NEWID() AS VARCHAR(36)),'-',' ') AS string

INTO...

A few ways. . . .

Since you haven't given us any sample data or DDL, these are untested and will have to be modified for your particular situation.

Dynamic SQL version...

Careful what you ask for!

SET NOCOUNT ON;

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN

...

I fail to see the point of this. Care to enlighten me? Why does it not matter which "emp_amount" is displayed? Data integrity is always important - I can't imagine...