peter478 (3/8/2012)

---

okay I know , but not what I want ... try to apply it on my example.

again: input parameter is date:e.g. 1.3.2012

DECLARE @dat1 as datetime

DECLARE @SQLString NVARCHAR(4000)

SET @dat1...

To answer when you should use it...I would avoid it unless there is a legitimate reason to use it. Often it gets used as a primary key which causes performance...

Well you could add an ISNULL to your query.

ISNULL(col1, 0) as col1

Or is that what you are trying to avoid? You have to either handle it in your query...

Eugene Elutin (3/8/2012)

---

Then, you may miss some updates!

There was a story remembered by some one here, about the company went bust...

You want the value of the variable so it is just string concatenation.

declare @MyVar varchar(10) = 'like this.'

declare @SQLString varchar(max)

set @SQLString = 'You append your variable ' + @MyVar

select @SQLString

Beginner_2008 (3/8/2012)

---

Sean Lange (3/8/2012)

---

Beginner_2008 (3/8/2012)

---

Sean Lange (3/8/2012)

---

Here is a good place...

At least a few rows for each table would make it a lot easier.

Beginner_2008 (3/8/2012)

---

Any...

Can you post ddl and some sample data along with desired results based on the sample data? Take a look at the first link my signature for how to post...

venoym (3/8/2012)

---

A split function will work well. Keep in mind that in compatibility for SQL 2000 you can't always use a function on a column. So you may...

Here is a good place to start. http://msdn.microsoft.com/en-us/library/ms175887.aspx

Two questions.

1) Why global temp tables? You are dropping a global temp table which means if you have another process using it you just dumped it in the middle of...

As explained previously in this thread, it is an IDENTITY.

http://msdn.microsoft.com/en-us/library/ms186775.aspx

saidapurs (3/8/2012)

---

Hi Tunnel,

Just for cross verification, like if you connected my instance from your server that log will generate in my Error log files &...

Cross join doesn't even make sense here. It is a single non-normalized table with two columns.

As Gail said, the best approach is to find a string splitter and cross apply....