Something like this is what you need. The splitter function allows you to do a set-based join to get your query results.

--sample date table

IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL

DROP TABLE #TempTable

CREATE...

The two basic forms of the statement are:

--the first table must already exist. You can use * if inserting ALL columns,

--otherwise you must give a column list

INSERT INTO existing_table

SELECT...

You should certainly consider these products. BTW, I do NOT work for this company, but just know they have a superior product for just the sort of things you seem...

I usually don't expect the ISDATE function to return predictable results because it is dependent on the specific date datatype you are converting to and often gives different results (0/1)...

Here's a function that does exactly what you want:

CREATE FUNCTION [dbo].[itvfFindPos]

(

@strInput VARCHAR(8000)

,@delimiter VARCHAR(5)

)

RETURNS TABLE WITH SCHEMABINDING

AS

RETURN

(

...

Not exactly clear on what you are trying to accomplish, but my first instinct is to suggest the STUFF function. You can google it.

 

Find your \Local Settings\Temp folder and delete any .tmp files you find there. These files don't seem to clean up after themselves and after awhile you get hundreds of them...

syadnan2408 (5/1/2013)

---

I was recently assigned a SSIS project for a client.

The requirements are;

Load data from 6 database tables into one excel sheet, while creating 4 new tabs for the new...

WITH cteStore (SalesPersonID,TerritoryID)

AS

(

SELECT 1,2 UNION ALL

SELECT 2,2 UNION ALL

SELECT 3,2...

The easiest method is GENERATE SCRIPTS:

Assuming that the PKs would always be in ODD/EVEN order would make me nervous. What if data has been inserted or deleted and the IDs are no longer sequential? What...

Bill.Smith (4/29/2013)

---

Any suggestion on how to create XML like this from SQL Server?

I was able to create the XML without the Metadata lines using, "FOR XML RAW ('Request'), ELEMENTS". ...

Here's an XML parsing procedure I use all the time. It shreds the XML into a table. Below that I modified the output of the second version to produce a...

IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL

DROP TABLE #TempTable

CREATE TABLE #TempTable (

[ID] INT IDENTITY(1,1) NOT NULL,

[MemberID] INT NULL,

[Event] NVARCHAR(50) NULL,

...

Here's what I came up with using dynamic SQL. To retrieve the column names dynamically it uses a function which I've included below.

DECLARE

@strSearch NVARCHAR(4000)

...