Viewing 15 posts - 12,061 through 12,075 (of 26,486 total)
Only thing I would change is the following:
SELECT
M.Manuf_name,
V.V_model,
count(R.Vehicle_reg) num
FROM
dbo.Rental R
inner...
May 11, 2012 at 6:00 am
Even if it is possible, I am going to go out on a limb here and say it may not be practical to do so.
It all comes back to why....
May 11, 2012 at 5:54 am
Without knowing your database and the data stored within, not much we can do to help you. You need to understand we can't see what you see from here.
I'm...
May 11, 2012 at 5:47 am
kirkm 55368 (5/11/2012)
I had a good read of the link you suggested. If anything its put me off asking anymore questions here, what I'm hoping to do doesn't sit...
May 11, 2012 at 5:43 am
Explain why you want delays inside your procedure(s) instead of having them finish as quickly as possible. What you are asking for really makes no sense from a database...
May 11, 2012 at 5:34 am
Other than being written using ANSI-89 style joins, I don't see anything wrong with the code. I have taken a few minutes to rewrite it using ANSI-92 style joins,...
May 11, 2012 at 5:28 am
Not really. What would make more sense is if you would provide the DDL (CREATE TABLE statement) for your table(s) involved, sample data (INSERT INTO statements) for your table(s),...
May 11, 2012 at 5:21 am
NevaMind (5/10/2012)
Lynn Pettis (5/10/2012)
Simple, after the imports and before the package completes, use an Execute SQL Task to update the last rundate in the table.
Well honestly, i thought of it...
May 10, 2012 at 9:59 pm
polkadot (5/10/2012)
May 10, 2012 at 9:54 pm
diat150 (5/10/2012)
indexes on the devicehistory table are as follows:
primary key = id
recorddate ascending = non unique, non clustered
datesubmitted ascending = non unique, non clustered
archived ascending...
May 10, 2012 at 8:42 pm
Is this what you are looking for?
declare @ThisDate datetime;
set @ThisDate = '7/12/2009 0:00:00';
select dateadd(yy, 1, DATEADD(MM, DATEDIFF(mm, 0, @ThisDate), 0))
set @ThisDate = '8/12/2009 0:00:00';
select dateadd(yy, 1, DATEADD(MM, DATEDIFF(mm, 0, @ThisDate),...
May 10, 2012 at 8:01 pm
Simple, after the imports and before the package completes, use an Execute SQL Task to update the last rundate in the table.
May 10, 2012 at 7:27 pm
Jeff Moden (5/10/2012)
So much time wasted.
Maybe, but it is my time to waste. I'm not going to apologize for hoping against hope for the best. I guess that...
May 10, 2012 at 6:45 pm
Just another tidbit of information, SQL Server Reporting Services can be intgrated with SharePoint as well.
May 10, 2012 at 6:41 pm
Jeff Moden (5/10/2012)
Ugh, Nope. Couple ah chickens though.
Okay, Just wanted to make sure you weren't in Wonderland or something. :w00t:
May 10, 2012 at 6:37 pm
Viewing 15 posts - 12,061 through 12,075 (of 26,486 total)