Viewing 15 posts - 466 through 480 (of 541 total)
David Burrows (3/9/2011)
AND CASE WHEN MG_BOOKING.TRADE_CD IS NULL THEN
CASE WHEN BA.TRADE IN (select distinct Item From dbo.Split(@trades,',')) THEN 1...
March 10, 2011 at 2:10 am
David Burrows (3/9/2011)
The case statements can be used as is in a WHERE clause ie
WHERE CASE .... END = 1
or
WHERE .....
AND CASE .... END = 1
Gails solution needs a bit...
March 9, 2011 at 9:47 am
Hi Gail and David,
Thanks a lot for your answers but would it be possible to convert your solution in a way that they can be included in the WHERE clause...
March 9, 2011 at 9:13 am
David Burrows (3/9/2011)
At a guess
If input parameter TRADE is singular then
CASE WHEN MG_BOOKING.TRADE IS NULL THEN CASE WHEN MG_BILL.TRADE = @TRADE THEN...
March 9, 2011 at 9:00 am
GilaMonster (3/9/2011)
March 9, 2011 at 7:58 am
GilaMonster (3/9/2011)
pwalter83 (3/9/2011)
GilaMonster (3/9/2011)
Could you post table definitions, sample data and expected result please?
Now this is really frustrating. Without even reading the question, you have replied in a template answer....
March 9, 2011 at 7:32 am
GilaMonster (3/9/2011)
Could you post table definitions, sample data and expected result please?
Now this is really frustrating. Without even reading the question, you have given a template answer. This way you...
March 9, 2011 at 6:53 am
Jason-299789 (2/23/2011)
February 25, 2011 at 3:58 am
I do not agree with your assessment - try re-reading it. Once it is set up, a SQL Agent job takes care of everything without manual input.
Okay Phil,...
February 25, 2011 at 3:16 am
Phil Parkin (2/25/2011)
Did you take a look at Jason's suggestion? It might work for you.
I studied Jason's solution but it doesnt seem to be according to the business requirement...
February 25, 2011 at 2:52 am
Koen Verbeeck (2/23/2011)
Log shipping (it has nothing to do with SSIS):http://www.sql-server-performance.com/articles/clustering/log_shipping_70_p1.aspx
http://msdn.microsoft.com/en-us/library/ms190640.aspx
http://msdn.microsoft.com/en-us/library/ms187103.aspx
This is more work for a DBA then for a developer (as are the other solutions I mentioned).
Hi Again,
So is...
February 25, 2011 at 2:34 am
In that case, wouldn't it be easier to implement replication, mirroring or log shipping instead of re-inventing the wheel?
In my opinion, log shipping is the easiest method.
Hello Koen,
Thanks for your...
February 23, 2011 at 8:05 am
Hi Phil,
Thanks for your reply.
The equivalent tables are on a different server. So basically, the scenario is that when the records are added to the tables in the database...
February 23, 2011 at 7:36 am
Hi Lutz,
Thanks a zillion for saving my day again !!!
Kind Regards,
Paul
February 14, 2011 at 2:53 am
Hello Lutz,
Thanks a ton for your solution. Actually, there is some additional information which I forgot to include. The problem is that the three columns- BK_PARTY, FW_PARTY, SH_PARTY have been...
February 11, 2011 at 2:52 am
Viewing 15 posts - 466 through 480 (of 541 total)