We are using TCP/IP, named pipes are turned off, shared memory is also enabled. Everything is on default ports on this box.

Ya i didn't have high hopes for UAC, but apparently it did work before. SQL Browser was turned off on this server, i turned it on, but still no...

The for-each look is your friend, along with some variable manipulation.

CREATE TABLE #table1(col1 nvarchar(1), col2 int, OrderMe int);

INSERT INTO #table1 VALUES('B','100',0);

INSERT INTO #table1 VALUES('A','200',1);

INSERT INTO #table1 VALUES('B','300',0);

INSERT INTO #table1 VALUES('C','400',1);

WITH CTE (col1,col2, OrderMe) as (

...

I wouldn't do it that way. My way would be to use the trigger (if i had to) to write the export data to another table, with a SQL...

Bacon

It just wanted some brains :hehe:

Casting is your friend here. Not all parts of that string you are concatting are of the same type. Make sure all elements are of the same type and...

vick.ram79 (7/15/2013)

---

Use local variables to hold the values of the passed parameters. And then use the local variables instead of the passed parameters. This has ALWAYS worked for us in...

What about using local variables to hold the value of the parameters at the start of the stored procedure? This always seems to work for me when i encounter...

Look at this article:

http://archive.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=createacommadelimitedlist

Use a variable to overrride the connectionstring property of the connection connecting to your everchanging database.

You can set the contents of the variable to components of getdate() to look...

From my brief stint as a CSA:

Caller (Older gentleman, with his first computer, whom I assumed had never seen a typewriter either): How do I enter lower case letters? My...

david_wendelken (1/6/2010)

---

Forgot to mention that when I want to tell someone privately, one-on-one, that they're being a jack-@$$ and need to stop whatever they're doing that's making everybody mad, that...

Johan van Tonder (1/6/2010)

---

Manic Star sites support 79032's supposed "whining" post about his unfair treatment in the family courts, and responds with "Poor baby, is that what you want me...