Viewing 15 posts - 4,801 through 4,815 (of 9,722 total)
The UNION ALL won't help because it will take the name from the first SELECT as the column names.
Jenni, please post Create Table scripts with INSERTS that contain dummy data....
January 26, 2012 at 6:44 am
Can I just add a note. Never, ever, design a database based off what the queries will be. Queries change. They get added, they get removed, they get entirely redesigned....
January 26, 2012 at 6:36 am
Surely you can charge it to another department's cost center? @=)
January 26, 2012 at 6:33 am
gmamata7 (1/25/2012)
Ah, good ol' Litespeed. Was this is a script generated by the Litespeed console?
What exactly are you trying to accomplish with the OUTPUT variable?
I have an existing...
January 26, 2012 at 6:16 am
Please be more specific about what you've tried. Show us the code where you added another column and it didn't work. Post the error that occurred. Give us an INSERT...
January 26, 2012 at 5:54 am
SQL Kiwi (1/25/2012)
Brandie Tarvin (1/25/2012)
Anyone can fly. You just throw yourself at the ground and miss.Been reading Douglas Adams recently, Brandie?
Hee. I was wondering how long it would take for...
January 26, 2012 at 5:36 am
Roy Ernest (1/25/2012)
Brandie Tarvin (1/25/2012)
I have been thinking about testing remote presentation at some U.S....
January 26, 2012 at 5:35 am
I wish I could attend all the international SQL Saturdays. That would be so much fun.
I have been thinking about testing remote presentation at some U.S. Saturday's though, and expanding...
January 25, 2012 at 12:35 pm
I have to agree with Sean. Use # 1. First of all, it adheres to the rules of normalization, plus it takes advantage of the fact that you have access...
January 25, 2012 at 12:33 pm
Try putting the results into a table then reporting off the table.
January 25, 2012 at 12:30 pm
Whenever you have an aggregate of any type in a UNION statement, verify that the datatype for that aggregate is the same in all sections of the UNION.
0 AS [ADV_EFT]...
January 25, 2012 at 12:28 pm
Jeff, I just saw this. Are you sure the issue isn't your connection? I see it set to Local. What happens if you set it to an actual server name?...
January 25, 2012 at 12:21 pm
Layman's explanation. Think of an Excel spreadsheet. Just one page. Now imagine it's filled with your banking information. The first 5-7 columns are your customer names and addresses, the next...
January 25, 2012 at 12:18 pm
I would be tempted to look at the code that enters the transactions and see if there is anything there that can be cribbed into your solution. But aside from...
January 25, 2012 at 11:54 am
jcrawf02 (1/25/2012)
Steve Jones - SSC Editor (1/25/2012)
SQL Kiwi (1/24/2012)
Steve Jones - SSC Editor (1/24/2012)
But you can ski?
I tried snowboarding once (in a supervised inside environment[/url]) and that was enough to...
January 25, 2012 at 11:40 am
Viewing 15 posts - 4,801 through 4,815 (of 9,722 total)