You're welcome. Thanks for letting us know you figured out a solution.

Well oddly enough since this is a sql forum I posted sample code for sql. The same concept will work in VBScript. Just look up vbscript string functions, then look...

Homework?

It is totally unclear from your post what you are trying to do. Clarify what you want to accomplish and post what you have tried.

krishusavalia (8/29/2011)

---

Hi Everyone,

I come across a problem and don't know what to do?

I have 2 tables. TableA and TableB.

TableA (All INT data type)

ID Percent ...

Depending on the size of the tables and the indexes in place it may be a bit faster to use inner joins instead of nested exists.

I might have missed something...

Francis McFaul (8/29/2011)

---

To SSCommitted,

This and other code was developed by their in-house Developers and has been around for years. Dynamic SQL are a fairly common method for them to...

Revenant (8/29/2011)

---

Sean Lange (8/29/2011)

---

No I think I knew what you meant. Seems like an extra step that just simple isn't necessary. Stored procedures are a great way to "store" your...

No I think I knew what you meant. Seems like an extra step that just simple isn't necessary. Stored procedures are a great way to "store" your sql. And they...

Francis McFaul (8/29/2011)

---

I've been working as a Contractor for an organization documenting their stored procedures and processes. In over 90% of their stored procedures they use dynamic SQL for...

sanujss (8/29/2011)

---

I have a date time as '4/26/2011 5:00'. I need to convert this to UTC format and find out the difference of this in seconds with '01/01/1970 00:00'. How...

Something like

declare @UNC varchar(50) = '\\wvsjnas01\DSData\Starbucks'

select right(@UNC, CHARINDEX('\', reverse(@UNC), 0) - 1)

Roust_m (8/28/2011)

---

Hi,

Just was wondering, from the best practices point of view, are there any disadvantages in using table valued parameters for your SPs in the application. E.g.: table valued...

Jeff do you have any experience using Nested Sets with multiple root level elements? for example in a menu system. I have used it in an org chart type of...

Look at BOL http://msdn.microsoft.com/en-us/library/ms187339.aspx

Check out Gail's blog. She has two great articles about just this behavior called parameter sniffing.

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/%5B/url%5D

http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/%5B/url%5D