Viewing 15 posts - 6,076 through 6,090 (of 7,631 total)
Suggestion: Temporarily add an XML column to your table and store the entire EVENTDATA in there.
Then you can query the actual EVENTDATA interactively, until you figure out what 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]
August 4, 2008 at 4:03 pm
post the SQL script.
[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]
August 4, 2008 at 3:58 pm
KMM (8/4/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]
August 4, 2008 at 3:04 pm
The smiley's appear when you have a space followed by a ")" followed by a space or an end-line. I try to put a tab or a character in...
[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]
August 4, 2008 at 2:11 pm
good luck and thanks for the feedback.
[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]
August 4, 2008 at 1:39 pm
You should note that my technique preserves the "time" part of the dates (including Getdate()) instead of knocking them down to midnight. This might produce slightly different results than...
[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]
August 4, 2008 at 11:47 am
please do not cross-post.
[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]
August 4, 2008 at 11:39 am
Jeff Moden (8/4/2008)
I wonder how they do running totals in data warehouses in SQL Server?
Either in pre-processing (the Load step of the ETL) or in post-processing (the Analysis client). ...
[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]
August 4, 2008 at 11:37 am
Try it like this:
ALTER procedure [dbo].[usp_GetDupes]
(@days int)
as
SELECT RX_NUMBER, FD_FACILITY_ID, POS_POS_FINALIZATION_NUM,
COUNT(RX_NUMBER) AS TALLY
FROM POS_DATA
WHERE POS_POS_FINALIZATION_NUM IN
(
SELECT POS_POS_FINALIZATION_NUM
FROM POS_DATA
GROUP BY POS_POS_FINALIZATION_NUM
HAVING (COUNT(POS_POS_FINALIZATION_NUM) > 1)
) AND
AND POS_DATESTAMP BETWEEN DateAdd(Day, -@days-1,...
[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]
August 4, 2008 at 11:22 am
stuart.hill (8/4/2008)
--------------------------------Msg 240, Level 16, State 1, Line 1
Types don't match between the anchor and the recursive part in column "AllDescr" of recursive query "cteIterate".
--------------------------------
There's not much that I 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]
August 4, 2008 at 11:13 am
Thanks for the feed back, JJ.
[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]
August 4, 2008 at 9:27 am
OK, sure.
First case:
jmclain (8/1/2008)
...
CREATE PROCEDURE [dbo].[POXML](
@strXML VARCHAR(2000)
)
...
EXEC sp_xml_preparedocument @XMLDocPointer OUTPUT, @strXML
BEGIN TRANSACTION
INSERT INTO PO(PO_ID, PO_DATE, CUST_PO_NBR, po_rcvd_dttm)
SELECT '1', podate,...
[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]
August 4, 2008 at 8:48 am
dbaker (8/4/2008)
- criticism smacks of double standards methinks
Please, explain?
[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]
August 4, 2008 at 8:10 am
Try this instead:
With cteServers as (
Select PC.PC
,PC.PC_DomainName
, Disks.Disk_Desc
, Row_Number() Over(Partition by Disks.Disk_Desc order by Disks.Disk_Desc) as N
From PC
LEFT JOIN...
[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]
August 4, 2008 at 6:53 am
dbaker (8/4/2008)
- better solution (for SQL200x) might have been
...
exec sp_MSforeachdb 'use[?];
...
[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]
August 4, 2008 at 6:42 am
Viewing 15 posts - 6,076 through 6,090 (of 7,631 total)