Duplicate post. Please direct all replies to the original thread. http://www.sqlservercentral.com/Forums/Topic1365421-146-1.aspx

Doh!!! You are right...

D.Post (9/27/2012)

---

Hi,

Before inserting the data, find out what the MAX(LEN(Col)) is for each column. Compare the results to your variable declarations and destination table design.

Btw, varchar(max) isn't recognized in...

I found this one a bit off. I assumed that the two lines setting IDENTITY_INSERT were typos because otherwise this entire batch would insert no rows. However if you fix...

dwain.c (9/26/2012)

---

Nice set up data Sean!

Using it, I'd like to offer a slightly less verbose solution:

SELECT *, WaitTime=DATEDIFF(minute

,CAST(check_in AS TIME)

,CAST(STUFF(appt_time, 3, 0,...

I see you are new around here. It is generally considered best to post ddl and sample data in a consumable format. I did this for you as an example...

Can you ddl and sample data for TableC? Also, a clear explanation what you are trying would help. I am not sure I understand your requirements.

create view DidYouTryIt as

WITH CTE AS(

selectcalcid,

salesamount,

productid,

ROW_NUMBER() OVER( PARTITION BY productid ORDER BY calcid) rn

from...

If that is what you used it is obvious you didn't read that article very clearly. If this is a one time...

Nice job posting ddl and sample data!!!!

i have a table with 3 columns. i want to get the salesamount for previous calcid for a perticular productid.below is script for table...

roh_ranjan (9/26/2012)

---

Hello Sean

What i mean to say that user have maximum right to perform addition/deletion/substitution.Assuming I/you have all access and now request came to add/delete/substitute user...

Well I know have another copy of the ddl and sample that somebody else wrote but I still don't know what you want out of this. I think you are...

KTG (9/26/2012)

---

Hi,

I am curious about how to determine how big a log file should be? Is there a standard forumla I can follow if I am not looking into things...

roh_ranjan (9/26/2012)

---

Hello Sean

Thank you for response.I completely agree what you are saying.If you see the above Jason response where he created temp table and show the hierarchy.In same table I...

roh_ranjan (9/26/2012)

---

Hello All, I have already provided the Cursor(sort of DDL) which are creating the tree view. Also i tried to provide the tree view result of cursor.Thank you re...