Viewing 15 posts - 10,456 through 10,470 (of 11,676 total)
Dinculescu Mihai (1/15/2011)
It was generated for migrating data over.
Migrating data from what to where?
In the same DB? In the same server? Or across different servers?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2011 at 6:19 am
What is EMPTY? Is it an empty string? A single space? Multiple spaces?
In the case it is an empty string, you better trim the column first and then check if...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2011 at 6:06 am
It works with me on SQL Server 2008 R2.
Are you sure there is not a typo in the name of ServerB?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2011 at 5:58 am
Can you give a little more information?
What version of SQL Server are you using? What service pack level?
What do the queries look like? Are you using a linked server?
Are you...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2011 at 5:49 am
If you are on your own, selling it will be tough. Companies usually don't just install everything on their computers. You have to convince them. And you have multiple people...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2011 at 5:45 am
Dave Ballantyne (1/14/2011)
A fairly cool (IMO) change ,superseding old articles, could be happening to SSC in the future.Comments ??
http://www.sqlservercentral.com/Forums/Topic1047170-433-1.aspx
I think it is a great suggestion.
But as mentioned in the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2011 at 12:07 pm
Alvin Ramard (1/14/2011)
If so many of you dislike a certain poster so much then why do you have to keep on talking about him?
It is like watching a horror movie....
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2011 at 12:01 pm
GSquared (1/14/2011)
Jeff Moden (1/13/2011)
Stefan Krzywicki (1/13/2011)
If they see a penny on the ground, they leave it there.
Maybe other folks will leave it, but I'll stop and pick it up. ...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2011 at 7:24 am
Ray K (1/14/2011)
Just because of his attitude, not only will I never recommend his books
Come on come on. Don't exaggerate. I hear they are just fine for starting a nice...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2011 at 7:21 am
munawargani2001 (1/14/2011)
Check out this link. It is just one step quick way.
This will work if the data comes out of a flat file.
However, no one in this thread has mentioned...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2011 at 7:04 am
Isn't it possible it was a self restart?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2011 at 6:54 am
Another solution, but harder to maintain and probably not so good for performance - is to set up triggers on tables that contain critical data. If a delete is performed,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2011 at 6:47 am
The second code will surely be much faster, but you've hard coded the condition into your statement.
Are you sure there will always be one row in table2 with col2 =...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2011 at 6:44 am
irobertson (1/14/2011)
Hi,Another way is to use a table variable to limit your values:
...
Just because I find it a bit easier to read than dynamic SQL...
You are right, that is a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2011 at 3:45 am
Niteen.gavhane (1/14/2011)
CREATE PROCEDURE testbizclose_remove
(
@Par int
)
AS
SELECT DAY FROM BIZ_CLOSING WHERE BIZ_ID = 802 and (case @Par when 1 then shift in( 1,4,6,7) when 2...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2011 at 3:14 am
Viewing 15 posts - 10,456 through 10,470 (of 11,676 total)