LutzM

Forum Replies Created

Viewing 15 posts - 2,386 through 2,400 (of 5,502 total)

RE: display a time based event

based on your description your orignal approach isn't that far off...
SELECT [event] FROM [yourTable] WHERE [date] = @currentdate
The "tricky" part is how you store the event dates in the [date]...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

December 16, 2010 at 4:33 pm

#1263789
RE: Looping though XML Subnode and pass the Identity value

Run the code.
Read the error meassge.
Try to figure out what it means (e.g. column name not defined in the referenced table?)
Try to resolve the issue.
If you can't figure...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

December 16, 2010 at 4:17 pm

#1263781
RE: Looping though XML Subnode and pass the Identity value

a) the end tag < / Ridge > has no start tag

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

December 16, 2010 at 3:12 pm

#1263763
RE: display a time based event

Hard to tell without knowing anything about your table structure...
Please provide more details. See the first link in my signature on how to do it to get a coded and...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

December 16, 2010 at 3:11 pm

#1263762
RE: Looping though XML Subnode and pass the Identity value

errmm... :unsure:
Did you notice what I mentioned as b) two posts before, restated in my previous post?

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

December 16, 2010 at 2:41 pm

#1263748
RE: Sequel job not completing

What happens if you'd run the following statements separately nad in the given order on database SedaliaHLB_RenCS (those are the sprocs called within the job steps) ?
Execute HLBInventoryCheckAllAccepted
Execute HLBInventoryCheckUnaccepted
EXEC HLBInventoryCheck

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

December 16, 2010 at 2:38 pm

#1263746
RE: T-SQL query giving errors in SQL 2008

I still don't understand.
What's the difference between @lastdate and convert(datetime, datename(month,@lastdate) + " " + datename(day,@lastdate) + " " + datename(year,@lastdate) + " 00:00") ?
If all you're trying to do...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

December 16, 2010 at 1:48 pm

#1263710
RE: Need assistance with a list and putting a value in a virtual column

Use a subquery (or CTE) to select the TOP 3 order VoteCount and join that back to your original table on Detailname in an update statement.
As a side note: ready...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

December 16, 2010 at 1:41 pm

#1263704
RE: Looping though XML Subnode and pass the Identity value

see item b in my previous post.
Side note: It usually helps if the error code is included in the post, not just mentioned...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

December 16, 2010 at 1:34 pm

#1263694
RE: Need assistance with a list and putting a value in a virtual column

I don't understand your requirement.
Please post table def, sample data and expected result in a ready to use format as described in the first link in my signature.

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

December 16, 2010 at 1:21 pm

#1263683
RE: T-SQL query giving errors in SQL 2008

I'm pretty sure you won't be able to run it using SS2000...
SQL Server requires single quotes, not double quotes.
The issue is within the last part of your statement: you'd need...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

December 16, 2010 at 1:11 pm

#1263676
RE: Looping though XML Subnode and pass the Identity value

There are severa lissues with that new file:
a) the end tag < / Ridge > has no start tag
b) There is a new node level (Mains) introduced that needs to...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

December 16, 2010 at 11:44 am

#1263632
RE: Looping though XML Subnode and pass the Identity value

It sure will.
Take the code snippet for the child table.
Replace 'Childs/Child' with 'Father' in CROSS APPLY T.c.nodes('Childs/Child') U(v)
Assign a different temp table to hold the output data, if needed for...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

December 15, 2010 at 4:20 pm

#1263216
RE: Are the posted questions getting worse?

Dave Ballantyne (12/15/2010)
...
Just the same old datatype issues 😉 forcing to a decimal type by adding '.00' corrects the issue
-- code removed (too much technical stuff in THE THREAD)
So you're...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

December 15, 2010 at 3:33 pm

#1263200
RE: help in my procedure

CELKO (12/15/2010)
...
ISO-11179 is big and hard to read. That is why I put it into English in my SQL PROGRAMMING STYLE book. The DoD and Feds are hot for it...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

December 15, 2010 at 2:11 pm

#1263152

Viewing 15 posts - 2,386 through 2,400 (of 5,502 total)