Viewing 15 posts - 2,731 through 2,745 (of 14,953 total)
CASE doesn't work that way in SQL.
CASE in SQL returns a value based on conditions. You're using it more like a VB version of CASE, where it executes code.
Convert...
November 29, 2011 at 10:54 am
No, this should not put any records in the table variable, the way it's written, if the CTE returns zero rows.
If you want it to return data from other tables,...
November 29, 2011 at 10:46 am
When it tries to parse/compile the command, it runs into the fact that the table is already created by an earlier statement. In a simple script, you can overcome...
November 29, 2011 at 9:56 am
Actually, if the source server is staying yellow, then that's not finishing. It's never getting to the transmit step. That means the problem is the data source.
I'm not...
November 29, 2011 at 9:48 am
Having "Others" as the column value is a matter of a Case or IsNull/Coalesce statement in the Select clause.
In the Order By, you can put a Case statement like:
Order By...
November 29, 2011 at 8:37 am
Did you update your data source in your SSIS package? If not, it's still expecting a column there, and you're probably getting lost data because of that.
Look at a...
November 29, 2011 at 8:33 am
Is the backup job set to run on a specific set of databases, or on "All databases", "All user databases", or "All system databases"? I've seen situations like this...
November 29, 2011 at 8:27 am
Have you checked the target and source servers to see if the activity is being held up by something normal like lock/block issues?
On the SQL server side, check sp_who2, or...
November 29, 2011 at 8:25 am
sturner (11/29/2011)
Thinking time is important, but only by half. The other half is actually documenting the results of your thinking processes along with any conclusions you came up with.
Definitely. ...
November 29, 2011 at 8:21 am
Those drivers are for copying the database from one server to another directly. If you need to save it to USB in between, they won't work.
Your best bet is...
November 29, 2011 at 8:20 am
Charmer (11/29/2011)
because i could select and update any records...but i couldn't alter any...
November 29, 2011 at 8:07 am
djackson 22568 (11/29/2011)
I'd encourage you to take some time to just think over the holiday season, when there usually is less work going on
HA HA HA HA HA HA, ROFL!!!!!!!!!!!!!!!!!!
Where...
November 29, 2011 at 8:05 am
Depending on your role, and possibly on specific permissions for your login or any groups your login is part of, you either need to be granted permission to create and...
November 29, 2011 at 7:23 am
Jack Corbett (11/29/2011)
November 29, 2011 at 7:17 am
Jeff Moden (11/28/2011)
TravisDBA (11/28/2011)
November 29, 2011 at 7:14 am
Viewing 15 posts - 2,731 through 2,745 (of 14,953 total)