Nice Grant. And great tip!

Thanks very much for the tip Sam. 🙂

In your original posting, I'd say it's the SELECT that's failing even before the WHERE is applied.

If you remove the third item in the SELECT it gives you back the...

This is a plain looping solution that reads the string character by character. It can handle input string of 2000 chars. String can start with 0, 1, or comma.

Bob, can...

Thanks Dave 🙂 Learned a few things.

Hi Dave,

Great article, thanks for pointing it out.

Can you explain your code a bit please? See comments in the code.

with cteWeeks(dte,WeekNo,RowN)

as

(

Select dte,WeekNo,row_number() over (order by dte) --...

Here's some code that should give you what you want if I understood your question properly.

You'll want to wrap this up in a stored procedure. Unfortunately doesn't look like the...

To connect to remote server:

[font="Courier New"]select * from openrowset('SQLOLEDB', 'Uid=myUsername;Pwd=myPassword;Server=ServerNameOrAddress;Database=AdventureWorks2000', 'exec dbo.proc_simple')[/font]