Viewing 15 posts - 3,106 through 3,120 (of 5,590 total)
byrdmom2 (9/28/2010)
I get the following error message:The isnull function requires 2 argument(s).
CC didn't count the parenthesis correctly. This should work:
--***get the information from both tables and concatenate date and city
select...
September 28, 2010 at 6:43 am
How about:
WHERE Column1 LIKE '%' + Column2 + '%'
Note that starting off with a '%' will mean that you won't effectively be able to use an index.
September 27, 2010 at 6:50 pm
pshaship (9/27/2010)
Hi,What is the difference between the results displayed by sys.objects & sys.all_objects
Very simply, whether system objects are included or not.
sys.objects:
Contains a row for each user-defined, schema-scoped object that is...
September 27, 2010 at 5:42 pm
How's this?
-- See how this starts off with a table and data in it?
-- If you had provided us the data in this format,
-- it would have made things...
September 27, 2010 at 4:33 pm
Put your query in double-quotes. From BOL:
Use double quotation marks around the query and single quotation marks around anything embedded in the query.
September 27, 2010 at 2:30 pm
How's this?
-- See how this starts off with a table and data in it?
-- If you had provided us the data in this format,
-- it would have made things...
September 27, 2010 at 2:20 pm
Brandie Tarvin (9/27/2010)
I know you're inserting INTO an Excel spreadsheet. I just don't...
September 27, 2010 at 2:13 pm
Kit, did you get a working solution yet on this? (It seems like the solutions offered by Chris and Brandie are working.)
September 27, 2010 at 11:37 am
Alvin Ramard (9/27/2010)
Alvin Ramard (9/27/2010)
WayneS (9/27/2010)
jcrawf02 (9/27/2010)
I of course immediately subscribed to your feedOkay, stupid question time. How do you subscribe to a blog feed? Are any special programs required?
Since...
September 27, 2010 at 11:27 am
jcrawf02 (9/27/2010)
Alvin Ramard (9/27/2010)
WayneS (9/27/2010)
jcrawf02 (9/27/2010)
I of course immediately subscribed to your feedOkay, stupid question time. How do you subscribe to a blog feed? Are any special programs required?
Since you...
September 27, 2010 at 11:24 am
Update: that didn't resolve it... back to square 1 :crying::angry:
September 27, 2010 at 11:16 am
jcrawf02 (9/27/2010)
I of course immediately subscribed to your feed
Okay, stupid question time. How do you subscribe to a blog feed? Are any special programs required?
September 27, 2010 at 11:03 am
CirquedeSQLeil (9/27/2010)
Sometimes we learn quite a bit through our articles and our blogs that we would not have learned otherwise.
So true. In fact, the last article that I wrote...
September 27, 2010 at 9:15 am
Jeff - just saw this thread after returning from my vacation. If needed, I can run this on a Vista Ultimate 64-bit laptop, on 2005 / 2008 (not R2). I...
September 26, 2010 at 10:32 pm
Phil Factor (9/26/2010)
September 26, 2010 at 2:11 pm
Viewing 15 posts - 3,106 through 3,120 (of 5,590 total)