Viewing 15 posts - 31 through 45 (of 46 total)
Here is everything you need, including the DDL, DML, and expected result set. I just combined everything so you don't have to refer to three different posts. You can open...
April 22, 2009 at 8:09 am
That's what I get for using Textpad (for the macros) to produce the sample dataset instead of SSMS, lol. Anyways, I PM'd the changes to you.
April 21, 2009 at 12:47 pm
I'll try to get you a better sample dataset. Working on it now.
April 21, 2009 at 9:27 am
Lynn Pettis (4/20/2009)
April 21, 2009 at 7:48 am
GSquared (4/20/2009)
If you don't use the "constraint" keyword, that command works.
create table #T (ID int);alter table #T add primary key (ID);
Just tested that and it worked.
Ah yes, it sure does....
April 21, 2009 at 7:30 am
I'll try to get better sample data tomorrow if that's what you require. Also, all the queries and DDL are there (some code is in the very first post). The...
April 20, 2009 at 3:34 pm
Lynn Pettis (4/20/2009)
FYI, the sample data for dbo.BackgroundViews does not have any data that matches the sample data for dbo.IPCITYISP.
I realize that, but I'd have to modify the queries to...
April 20, 2009 at 3:03 pm
Lynn Pettis (4/20/2009)
April 20, 2009 at 2:23 pm
Lynn Pettis (4/20/2009)
April 20, 2009 at 1:51 pm
I believe I finally figured it out. I was able to queue up 7 reports successfully without any errors or 'default' reports being pushed out. It all lies in the...
March 25, 2009 at 11:49 am
I am able to run a file share-based subscription successfully. I put the credentials in when I originally created the subscription. The only problem I have now is that unless...
March 24, 2009 at 3:23 pm
makjain (12/2/2008)
Hi Friend,I m getting below underlined error message when i tried to update the table.
A correlation name must be specified for the bulk rowset in the from clause.
Try this...
December 2, 2008 at 9:36 am
Try something like this (untested):
UPDATE tblImage
SET imgData = (SELECT BulkColumn FROM
OPENROWSET(BULK N'F:\MUKESH PERS\Images\200810A0\Image026.jpg', SINGLE_BLOB))
WHERE (imgID = 5)
Of course, replace the imgID = 5 with the correct ID.
December 1, 2008 at 10:34 am
makjain (11/29/2008)
In...
December 1, 2008 at 9:04 am
No one has any advice on this? Do you require more information?
November 26, 2008 at 12:46 pm
Viewing 15 posts - 31 through 45 (of 46 total)