Viewing 15 posts - 12,346 through 12,360 (of 22,214 total)
And if you go to Tools -> Options -> SQL Server Object Explorer -> Scripting, you can exercise some control over how scripts are generated.
June 12, 2011 at 4:57 am
Yasir Masood (6/11/2011)
That worked. Thank you
Not a problem. Glad I could help. Also, thanks for posting that it worked. Makes it better for someone reading this later.
June 11, 2011 at 10:00 am
Not having your data, it's hard for me test this, but you can try moving the other WHERE criteria into the JOIN clause. When dealing with OUTER JOINs, filter criteria...
June 11, 2011 at 9:26 am
muthukkumaran Kaliyamoorthy (6/11/2011)
ting.kris (6/11/2011)
Spam. Please don't respond.
You don't need to do that. Just click on the Report button and ignore the post otherwise.
June 11, 2011 at 5:52 am
shiv-356842 (6/11/2011)
Hi Team,What is difference between Migration and Upgradation... please guide me.
Tx
I'm not sure what context you're asking the question, but here's my swipe at an answer.
A migration is moving...
June 11, 2011 at 5:51 am
In addition to the order, you also have to worry about permissions. Do you have permissions to create the objects? Once created, do the objects have permissions to see other...
June 11, 2011 at 4:56 am
Depending on how you're defining transactions, you could go the Performance Monitor route, which just counts transactions, or you may need to set up a server side trace. You can...
June 11, 2011 at 4:52 am
One piece of advice. You're writing your queries using the ANSI 89 standard on joins. Don't do that. As soon as you get to outer joins you're going to have...
June 11, 2011 at 4:50 am
Man, I couldn't have been further off track. I totally missed several key words and tricky phrases in the original question. Sorry for any confusion tossed into the mix.
June 10, 2011 at 4:18 pm
I wrote an article outlining several ways to get versioned data. Latest date is not any different than latest version. Take a look at this[/url] and post back here if...
June 10, 2011 at 2:40 pm
You're performing either ANSI 89 style joins. Instead, you should use the ANSI 92 style
SELECT ...
FROM TABLEA AS a
JOIN TABLEB AS b
ON a.ID = b.ID
LEFT JOIN TABLEC AS c
ON b.NewID...
June 10, 2011 at 1:46 pm
Marios Philippopoulos (6/10/2011)
Grant's suggestion is something I had never considered before.
So, if I...
June 10, 2011 at 1:38 pm
You're not using the right protocol or a protocol is not enabled on the server is my first thought? Or, maybe you've got the server name wrong? Maybe the name...
June 10, 2011 at 12:50 pm
I know that we had lots of apps with issues, but I have to say, most of our servers were up at least 3-4 months at a time. They'd probably...
June 10, 2011 at 12:49 pm
I'm not entirely sure I understand the problem as you defined it, but if I understand correctly, aren't we just talking about a series of queries with parameters? You pull...
June 10, 2011 at 12:14 pm
Viewing 15 posts - 12,346 through 12,360 (of 22,214 total)