Glad to hear it.

If you have a chance to post what you found the problem to be, that may be helpful to someone that ends...

If I understand you correctly you're wanting to have your app pass through credentials of accounts from users to the SQL Server.

I'll be honest ... I really don't like the...

Without seeing exactly what you're trying to execute it's very difficult to help you.

TRY blocks work as a block .... you can put as much code in there as you...

There is really no need whatsoever of having an order 1, 2, 3 ... for each separate user. Think more in terms of just storing the data reliably and...

Eugene touched on this, but let me expand a little ...

Join performance will be faster using as small of a numeric key as possible. Small is important because the...

If your code is terminating in the CATCH block that means you have an error. Without seeing your actual code,...

John Walker-232274 (6/29/2010)

---

For some reason after the first INSERT INTO XXX... statement it jumps to the CATCH block and does the ROLLBACK. Why aren't the other Updates and Inserts...

I don't know the SSIS...

PHXHoward (6/26/2010)

---

Hi, I have searched around prior to asking.

I've written an SSIS package that takes addresses from a flat file and puts them into a table.

It has been working fine...

Wayne's solution above is by far the most efficient of the 3, especially if you already have a tally table set up. (Not sure why inferior suggestions were posted...

valeryk2000 (6/28/2010)

---

Sorry for naive question (it's so hot on the East Coast!)

Query:

SELECT * From myTbl WHERE A="20" and B="167"

How the engine is going to process:

1. select all A's and...

ankur_dba (6/26/2010)

---

Hope this helps...

declare @stmt nvarchar(max)

declare @whrcls nvarchar (max)

declare @param int

set @param=1

set @whrcls=''

set @stmt = 'SELECT SALESPERSON,

...

Based on the information you've provided, I would suggest splitting the statement into two parts. The one part for cases when you want to return all countries and the...

If you want to crosstab the data into X columns where X is dynamically determined, you will need to use dynamic SQL. Jeff Moden has a nice article about...

As a side note ... don't use (n)char/varchar for date fields ... use a datetime datatype and save yourself a lot of trouble.