If it's all one transaction, batching it will have no effect. The transaction will...

Ananda

Just as a matter of interest, why are you wrapping a SELECT statement in an explicit transaction?

John

It's best to let your presentation layer handle things like this. If you have to do it in the database layer, you can use FOR XML to concatenate the...

It's worth having a look in the default trace next time it fails to see whether the activity is recorded in there. Another thing that's worth doing is piping...

I've just tried your script, and it looks like I was wrong about not being able to use a variable in your BACKUP statement, so ignore that comment. I...

You can't use a parameter for the database name in a BACKUP statement. You need to use dynamic SQL instead, or find some other way of building your SQL...

Leave it as it is, otherwise it'll only grow again, wasting system resources and causing fragmentation. If there's been a one-off event that has caused the log to grow...

Hugo

I was about to make precisely that point. Paul is quite right, since the question asks how to get the proc to do an index seek. But it...

Dwain's method is more efficient, since it doesn't involve string conversions. Granted, it doesn't give you the AM/PM, but do you really need that?

If you want proof, run this...

kiran.rajenimbalkar (2/17/2012)

---

is there any function is in the sql server to generate new ID(as like sequence number) every time while inserting the rows from the front end(like front report) to...

varchar does not mean varchar(max) - it means varchar(30) when CONVERTing.

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

The 103 date format means dd/mm/yyyy, so that explains the result of the first statement. The second one returns...

dwain.c (2/17/2012)

---

On the other hand, if code may change over time for a part_id, maybe the intention is to capture the current code at the time of the order? ...

Maybe, but that doesn't show up in the sample data he posted.

You're way...

Oops - wrong thread! Don't know how that happened.

John

I understand what you're trying to do, although I don't know what you meant with that partial code about the join. However, please, please don't do it like this....