Viewing 15 posts - 8,191 through 8,205 (of 9,643 total)
I don't disagree that it would be nice addition, but there is a work-around. Also it would be nice if people would use the IFCodes period. How many...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 30, 2008 at 9:43 am
J (7/30/2008)
Ignore this posting, I am just subscribing to this thread. If anyone knows how to subscribe without making a dummy post, let me know. Regards
On the top right hand...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 30, 2008 at 8:38 am
MrBaseball34,
You do make some good points. There is way to get your SQL Code to look better and it is available on this site, http://extras.sqlservercentral.com/prettifier/prettifier.aspx, just not well-known. ...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 30, 2008 at 8:14 am
Mark Harr (7/30/2008)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 30, 2008 at 8:11 am
Michael Taylor (7/30/2008)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 30, 2008 at 7:45 am
Oh yeah, it really is a good editorial because it has sparked debate. Just because I don't agree with the opinion in the editorial doesn't mean I didn't enjoy...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 30, 2008 at 7:23 am
I'll admit I'm in the "USE stored procedures camp" and one of the main reasons is this quote from your editorial which you use as a reason to NOT use...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 30, 2008 at 7:20 am
g.raghunathan (7/29/2008)
My main table XXX_FLOW has : 125638737 records in it and
My SP : Billing_Completed_Flow access a...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 29, 2008 at 7:27 pm
You can add them to the SQLAgentUserRole in msdb.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 29, 2008 at 1:52 pm
The authentication method is Instance based not Server based so if I have 2 instances 1 can be Windows only and 1 can be mixed.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 29, 2008 at 1:49 pm
GilaMonster (7/29/2008)
Rename the table and see who complains? 😀
I like it:D
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 29, 2008 at 1:47 pm
Select @Count = @@ROWCOUNT
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 29, 2008 at 12:07 pm
GSquared (7/29/2008)
Jack Corbett (7/29/2008)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 29, 2008 at 12:03 pm
Thanks guys. I thought about messing with the scripting options. I'll have to compare them on both machines.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 29, 2008 at 11:58 am
In a situation where I only want to sum cd sales for cd's in the Opera and Classical categories you could do something like:
SUM(IIF(category = "Opera" Or category = "Classical",...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 29, 2008 at 11:03 am
Viewing 15 posts - 8,191 through 8,205 (of 9,643 total)