Viewing 15 posts - 8,446 through 8,460 (of 11,678 total)
Martin Schoombee (12/16/2011)
srik.kotte (12/16/2011)
Not from BIDS. I want something like that in sql agent.
SQL Agent is a scheduling tool only...not a development platform. You cannot create components for user interaction...
December 19, 2011 at 5:34 am
Put the 3 EPT's inside one container and enable transactions on that container.
December 19, 2011 at 5:30 am
Check out Integration Services (SSIS).
It allows you to build a package that extracts the data from the Access table and dumps it into the SQL Server table. You can schedule...
December 19, 2011 at 5:24 am
SQL Kiwi (12/17/2011)
Are the people who use SAP called saps*?* A foolish and gullible person
In Belgium, most business users pronounce the product that way.
It usually takes them saying it 4...
December 19, 2011 at 12:04 am
sqlfriends (12/16/2011)
Koen Verbeeck (12/16/2011)
* you can use the MERGE JOIN to join the two datasets together. The input needs to be sorted, so if your flat file...
December 18, 2011 at 11:31 pm
logicinside22 (12/16/2011)
that's why it says No SSIS Included..
But it doesn't say DTS included...
December 18, 2011 at 11:24 pm
kdnicholsster (12/16/2011)
I think you are correct it is just a column for audit purposes.What else can I use?
Many thanks for your help. I need to get this going.
If there...
December 16, 2011 at 7:08 am
jcrawf02 (12/16/2011)
Fricking case insensitive, I was returning all caps as stored in the db, default countyname in the included maps are proper case.
Oh well, at least I figured it...
December 16, 2011 at 7:00 am
Then add that column in your select list and add a GROUP BY clause over that column.
That way you get your result for every date in the LastUpdatedDateTime column.
Question: does...
December 16, 2011 at 5:59 am
kdnicholsster (12/16/2011)
Hello Koen and all,Thanks for your reply. Can you provide an example to get today's date and a date range.
I don't know your database. Do the tables have...
December 16, 2011 at 4:51 am
Regarding the first one:
if you enter the URL of the second instance, it will probably be listed under Recent Sites and Servers the next time.
Regarding the second one:
you can install...
December 16, 2011 at 3:32 am
Is it possible to upload the images as an attachment of your post. (look below at the post options, there is a section called attachments).
I can't see Imageshack images from...
December 16, 2011 at 3:00 am
That is probably because of the cache. It makes your reports run faster if they are called multiple times in a row, but it can give problems if the data...
December 16, 2011 at 2:58 am
If I get this correctly, you are selecting 16 integers with 16 different queries. In those queries I don't see a date somewhere. So my best guess is that you...
December 16, 2011 at 2:56 am
Viewing 15 posts - 8,446 through 8,460 (of 11,678 total)