Viewing 15 posts - 5,011 through 5,025 (of 7,631 total)
Jerry Hung (10/30/2008)
Interesting, but you can get by with the JOINSELECT * FROM Person.Person P
INNER JOIN (
SELECT FirstName = 'Jean'
) T ON P.FirstName = T.FirstName
COLLATE Latin1_General_CS_AS -- works
[/code]
This does not...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 30, 2008 at 2:15 pm
jeanlibera (10/30/2008)
This query does not work:SELECT * FROM INT_AUX_LISTING
WHERE FIRST_NM IN ('Jean')
COLLATE Latin1_General_CS_AS
The error is:
Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'COLLATE'.
Yes, because COLLATE can...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 30, 2008 at 2:12 pm
Scott MacCready (10/30/2008)
Version B is the script you get from the 'script to' command in the SSMS GUI.
When embedded in the t-sql script, it fails.
When...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 30, 2008 at 1:09 pm
I am between meetings here, but let me quickly call out three suggestions:
1) See my Blog (in my signature) or just downlaod this zip file: http://www.movingsql.com/dnn/LinkClick.aspx?fileticket=c7EJbXre%2fLg%3d&tabid=125&mid=461 which the...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 30, 2008 at 12:26 pm
We cannot see the error from here. Could you please tell us what it is?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 30, 2008 at 10:40 am
h.schlais (10/30/2008)
Should the END CONVERSATION be wrapped in an IF to avoid ending a conversation with a NULL handle ?
Well, if should be protected by an IF. I usually...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 30, 2008 at 7:43 am
Suresh B. (10/30/2008)
Both versions report success in the messages tab when run. Nonetheless, the table survives.
Both versions reported report success does not mean they executed the DROP TABLE part. IF...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 30, 2008 at 7:31 am
This should do it:
Select DepartmentId, Departmentname
From Department
Left Outer Join Employee ON Employee.DepartmentID = Department.DepartmentID
Where Employee.DepartmentID IS NULL
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 29, 2008 at 9:38 pm
naidussdba (10/29/2008)
I have to Display List all the departments that don’t have any employees(Without using sub query).
So why this unusual restriction?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 29, 2008 at 9:32 pm
Jeff: just because they're not out to get you, doesn't mean that you can't be paranoid.
(p.s. This is "Humor" also.)
😀
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 29, 2008 at 9:07 pm
I am confused. Does version B work or not?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 29, 2008 at 8:54 pm
h.schlais (10/29/2008)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 29, 2008 at 7:26 pm
Yes, but "Well-Formed" XML includes both Documents and Fragments.
If this is really important to you, I think that you could just test whether the first character is an "<" or...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 29, 2008 at 3:14 pm
This is nice, but it is not what was asked for.
Here is a link that explains how to get better results from these forums: http://www.sqlservercentral.com/articles/Best+Practices/61537/.
Here are the things that would...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 29, 2008 at 3:06 pm
I am not aware of such a rule.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 29, 2008 at 2:39 pm
Viewing 15 posts - 5,011 through 5,025 (of 7,631 total)