Viewing 15 posts - 7,381 through 7,395 (of 9,720 total)
It sounds like your user is possibly confused. But here's a quick Replication primer that might help you speak to him about his needs.
In every version of replication (Merge, Transactional,...
September 27, 2010 at 11:53 am
So far as I know, Management Studio does not have a debug tool.
Could you rephrase your question?
September 27, 2010 at 11:44 am
Wait. I'm confused. Are you selecting from an Excel spreadsheet or from a SQL Server table (dynamically generated)?
I know you're inserting INTO an Excel spreadsheet. I just don't understand the...
September 27, 2010 at 11:39 am
CirquedeSQLeil (9/27/2010)
Brandie Tarvin (9/27/2010)
Anybody know of a way to track readers on LJ?What is LJ?
LiveJournal.
September 27, 2010 at 11:36 am
CirquedeSQLeil (9/27/2010)
Brandie Tarvin (9/27/2010)
Because he can't afford all the others. @=) It's not just the dentist he has to pay, you know. Daughters expect kickbacks whilst they slumber.
A mouth full...
September 27, 2010 at 11:35 am
Kit G (9/27/2010)
The part makes my head hurt is the joining the table to itself. Know of any articles about that which might help make my head hurt less?
It's...
September 27, 2010 at 11:26 am
Because he can't afford all the others. @=) It's not just the dentist he has to pay, you know. Daughters expect kickbacks whilst they slumber.
September 27, 2010 at 11:21 am
I could look this up, I'm sure, but since we're on the topic of blogs, I'm going to be lazy (besides I can't look it up right now because if...
September 27, 2010 at 11:19 am
CirquedeSQLeil (9/27/2010)
Put something out there, debate it and if you are wrong - take your lumps and make a correction.
That's how I learned SQL. I tried to help out...
September 27, 2010 at 11:15 am
AhHA! A coworker figured it out. The System log had a whole bunch of "Side by Side" errors, referring to access denied on several different .dlls and other files. Turns...
September 27, 2010 at 9:04 am
I appreciate the advice. I do want to know what happened, though, so we can prevent it from occurring again.
The last time we "lost" a resource on the cluster--the Agent...
September 27, 2010 at 8:58 am
Okay, here's redone code taking into account the event date & time columns being on the same row. However, you're making an assumption that Event 1's menu will always be...
September 27, 2010 at 8:08 am
Chris, your code doesn't do what he wants Menu1 and Menu2 to do.
Also, you forgot to remove the # sign from your table name. Since he's a newbie and didn't...
September 27, 2010 at 7:51 am
Kit,
Try using DatePart, DateAdd, and CharIndex in your code. It'll make your select statement a lot less messy.
select Venue as VName,
address1 as VAddr1,
city + ', ' + state...
September 27, 2010 at 6:11 am
Glad I could help.
September 27, 2010 at 5:14 am
Viewing 15 posts - 7,381 through 7,395 (of 9,720 total)