Viewing 15 posts - 76 through 90 (of 224 total)
Ralf, do I understand this correctly? You execute a string that reads:
SELECT * INTO SQLTAB FROM TRANSFER.LOCAL.TRANSFER.AS400TAB
I've never called a DTS package from T-SQL like that. Can you elloborate on...
October 5, 2005 at 6:27 am
Yes, agreed. This generic lookup table is not the best idea. Nonetheless, I really don't believe that calling the quality of this site into question, or questioning the editing prowess of...
September 27, 2005 at 7:09 am
Gotcha. You're right - truly fitting. Sometimes you answer these posts so quickly it's like having you on IM.
Thanks again. RH
September 15, 2005 at 1:40 pm
Ahh - both of you, thanks so much. The quoted identifier issue and the nvarchar(128) - makes perfect sense.
Remi - didn't recognize you...didn't your userid used to be Remi...
September 15, 2005 at 1:25 pm
Thanks. I read the Dynamic Search Conditions - you and Noeld suggested that one yesterday. I will certainly read the other two.
I tried using singlequote+singleqote instead of double quote, but...
September 15, 2005 at 1:02 pm
Oops. I just realized that someone suggested that to me before and I forgot to go back and read it.
Thanks. RH
September 14, 2005 at 2:30 pm
Yes, you're right. I use CASE all the time in SELECT statements and until you said something, I didn't realize how poor my CASE syntax was.
There is a big difference...
April 6, 2005 at 12:37 pm
Remi - it worked like a charm. My last error was based on my own typing mistake.
Thanks for your advice and help!
Ryan
April 5, 2005 at 9:41 am
Thanks Remi. Unfortunately, I am still getting the same error trying to add this as a "constraint expression" in Enterprise Manager. The error I am getting is:
"Error validating constraint ck_buildings. ...
April 5, 2005 at 9:29 am
Thanks for the reply Remi. Let me restate my logic - I think it was flawed. I have multiple conditions I would like to protect. Can I accomplish this in...
April 5, 2005 at 8:50 am
You have to use affinity mask to use all 8 logical CPU's? That doesn't sound correct to me. Based on the current setting to use all CPU's, SQL should probably...
March 23, 2005 at 2:38 pm
Rog Pike, not trying to be argumentative here, but your posts on this site seem to be advertisements. Maybe you should contact the guys and gals of sqlservercentral.com and pay...
March 18, 2005 at 1:13 pm
Brian, thanks so much for the recommendation. I just ordered a used copy of Rebecca Riordan's Designing Relational Database Systems .
Ryan
March 18, 2005 at 11:36 am
Still hoping someone out there may have a suggestion...
Has no one read a single data modeling book that was worth the currency spent on it?
March 18, 2005 at 11:03 am
Viewing 15 posts - 76 through 90 (of 224 total)