Viewing 15 posts - 4,786 through 4,800 (of 5,504 total)
sudarsanan.kaliyamurthy (11/13/2009)
I have attached the sample data and the required table.
Well, doesn't really look like it...
A table definition would be something along CREATE TABLE... and sample data would be INSERT...
November 13, 2009 at 9:45 am
Do you have any chance to modify the table structure?
It would be a lot easier to query if you'd have a table with
ID, DateValue, Curr, and Amt.
To differentiate between...
November 13, 2009 at 4:16 am
Please see the links in my signature regarding Croos Tab and Dynamic Cross tab.
If you need further assistance please provide sample data in a ready to use format as described...
November 13, 2009 at 3:55 am
Another option would be: get DBA's you trust.
The DBA job is mostly "underestimated" in terms of the requirements a person in such a position need to meet.
And one of those...
November 13, 2009 at 3:48 am
Jeff Moden (11/12/2009)
Heh... take a look, Lutz. The person who provided the data isn't even the OP. 😀 I'm out of here.
@lcarrethers: I'm sorry!! :blush: Didn't notice that...
November 13, 2009 at 3:20 am
You might want to have a look at the following link:
http://www.sqlservercentral.com/articles/T-SQL/68467/
I think it has all the information to resolve the task you ask for.
If you don't feel confident using the...
November 13, 2009 at 3:07 am
DBA-640728 (11/12/2009)
thanks for you answer:yes it works, but it has to be (11,6),
conflicts with
DBA-640728 (11/12/2009)
yes i do have two values greater than 99999.99
DECIMAL(11,6) will result in...
November 12, 2009 at 4:22 pm
Supriya.S (11/12/2009)
November 12, 2009 at 3:51 pm
Here's another solution based on ROW_NUMBER.
It covers the issue of having code is null and location is not null.
Comparing the two row_number solutions will result in almost identical execution...
November 12, 2009 at 2:17 pm
It seems like you couldn't find the time to see, read, understand, and follow the article in the link in Jeffs signature...
[SET SARCASM ON]
Maybe it's easier if you follow the...
November 12, 2009 at 12:48 pm
One thing up front:
Your table definition for @tTrip is not normalized.
I strongly recommend to consider changing the structure to have only one DrID column and myabe an addtl. column for...
November 12, 2009 at 10:04 am
Glad I could help and sorry it took that long to figure out what you've been looking for...
November 12, 2009 at 12:43 am
J-F Bergeron (11/11/2009)
Let's try it with a covering index:Try to create a nonclustered index on CxToken, CxStatus that includes EcxLastTime (included column). ...
@ J-F: Just a side note: This...
November 11, 2009 at 3:54 pm
... still trying the second path ... (reducing the number of calls)
Would the structure of your procedures (especially in terms of number and type of parameter per proc) allow the...
November 11, 2009 at 3:35 pm
Please have a look at one of Gails great articles:
The article describes several options, analyzing pros and cons.
November 11, 2009 at 2:59 pm
Viewing 15 posts - 4,786 through 4,800 (of 5,504 total)