Could you post some sample data in a readily consummable format for loading your tables and the expected results of the query based on the sample data?

For assistance in this,...

Using the code from earlier in the thread, here is how it could be written using two CTE's.

with myTableCTE as ( -- This CTE creates the column field_C that is...

Chris Kitchen (8/3/2009)

---

Hi,

I'm wanting to make use of the new [Date] data type in SQL Server 2008 but I'm having a problem. I have a .txt file that contains...

It could take several minutes for a the cluster to failover if the active node should crash. All sessions would be disconnected during that time.

Not sure what you could...

Allister Reid (8/3/2009)

---

I would also recommend that you go with Lynn's solution - this kind of un-normalised view should only really be used for display. In the interests of...

I have tried rewriting your code such that I could read it easier.

Please review both the SELECT and UPDATE statements. Let us know if the SELECT statement returns what...

In addition, the code you are posting may not work as written.

So, the addition of two columns in the stored procedure definition also resulted in the stored procedure returning two addtional columns as well, correct? Are these additional columns also...

rboggess (8/3/2009)

---

I didn't say "lack of experience" -- I...

Here is my delimited split dunction for nvarchar values.

Show us with some actual code. I can't figure out...

How about posting the table DDL, sample data, and expected results. Please read the first article referenced in my signature block about asking for help. Follow the instruction...

After first fixing the missing comma after field_c in your code, you will get the following error:

Msg 207, Level 16, State 1, Line 11

Invalid column name 'rowNum'.

You can't use the...

John Paul (8/3/2009)

---

When the sub Store procedures (sp2) executes , it gives ouput of 6 columns ,

but it need to insert 4 Columns insert into #temp table ,...

JC (8/3/2009)

---

Hi Folks

I am trying to incorporate a CAST statment into my CASE statements and am not having any luck and do not know if that is even possible.

This is...