Viewing 15 posts - 3,526 through 3,540 (of 14,953 total)
That's essentially either two different reports with different queries, or one complex query that uses that parameter to determine which of two Select statements to use.
I'd go with two reports....
August 16, 2011 at 9:44 am
What credentials is the job running under? Not your credentials (those are what are used when you run from BIDS), but the job itself, SQL Agent as well. ...
August 16, 2011 at 9:42 am
nadabadan (8/15/2011)
troe_atl (8/15/2011)
August 16, 2011 at 7:55 am
Michael Valentine Jones (8/15/2011)
GSquared (8/15/2011)
...Assertion in an interview that threw me, "We have a lot of mission critical data, but it's okay to lose a day's worth of it because...
August 15, 2011 at 2:49 pm
Only question that ever threw me, "You come across as really arrogant. Have you ever made any friends?" I'm more used to coming across as hyperpedantic than arrogant....
August 15, 2011 at 1:41 pm
Are the dates the column headers?
If so, you should be able to query the table using OpenRowset, and then pivot it in T-SQL, instead of in an SSIS connection.
August 9, 2011 at 11:23 am
GilaMonster (8/9/2011)
Why are you installing Enterprise edition on a client OS?
Yep, I missed that in the question title. Can't do that.
August 9, 2011 at 11:19 am
How about just using Union All operations?
select CustomerID, DocNum, DocDate, 'Due Us' as Acct, DueUs as Ammt
from YourTable
Union All
select CustomerID, DocNum, DocDate, 'Due You' as Acct, DueYou
from YourTable
Union All
select...
August 9, 2011 at 11:17 am
What all are you trying to install?
Express Edition? Dev Edition? SSRS? SSAS?
There shouldn't be a problem installing the database engine and Management Studio. Are you installing...
August 9, 2011 at 11:13 am
You can use DDL triggers to fire on creation of a procedure. They can check values in tables. Will that do what you need?
August 9, 2011 at 11:11 am
Can you use a stored procedure instead of a function?
August 9, 2011 at 11:07 am
The only good solution will be to normalize. You could get some very slight performance improvement out of doing your string manipulations at the application layer instead of in...
August 9, 2011 at 6:43 am
SQLRNNR (8/8/2011)
GilaMonster (8/8/2011)
GSquared (8/8/2011)
Grant Fritchey (8/8/2011)
August 8, 2011 at 1:45 pm
Definitely split it out into a sub-table. That'll make it a lot easier to work with, and it will be faster to update, query, etc.
August 8, 2011 at 12:52 pm
Viewing 15 posts - 3,526 through 3,540 (of 14,953 total)