Viewing 15 posts - 2,056 through 2,070 (of 5,502 total)
There are several issues being unclear:
1) Why are there three rows for 5,C,F in @T but none for 5,C,T?
2) Why is the row for 5,C,F in @T and not 5,C,T?
3)...
January 20, 2011 at 11:36 am
Please post your expected result either as a list of SELECT statements or as a comma separated list.
Your verbal description is rather confusing.
And why no subqry or CTE?
January 20, 2011 at 10:50 am
CELKO (1/20/2011)
ROW_NUMBER() will, effectively, sort the list, then give...
January 20, 2011 at 10:37 am
bvkrishnareddy.bandi (1/20/2011)
No, it really a large data base, that's the reason in place of communicating directly with database, to communicate with that xml file?
Just consider the following scenario:
Let's assume you...
January 20, 2011 at 10:08 am
allin1 (1/19/2011)
Most of this is on paper still. But planning to implement soon.
Ideas on the " Mapping Loggic " would help too.
I decided with first 10...
January 19, 2011 at 4:30 pm
Are you sure you're searching the correct folder?
Do you see the sp_batch_params procedure?
How did you notice it's missing? Do you get any error message when calling the sproc? If so,...
January 19, 2011 at 2:10 pm
Joe,
why do you insist in using the resignation_date column?
As mentioned in my previous post, there is a high chance of data inconsistency.
Example (repeated from before):
member_id, group_id, membership_date, resignation_date
ABCD,G1,20110101,20110218
ABCD,G2,20110102,NULL
This is a...
January 19, 2011 at 1:56 pm
One reason might be there are simply no rows in the table variable.
Either there are no data in the app_error_log table or your queries return no data.
As a side note:...
January 19, 2011 at 11:37 am
One possible cause is using a scalar function in query A.
The query costs in the execution plan tend to be "inaccurate" down to "plain wrong".
You'll get much a better comparison...
January 19, 2011 at 11:23 am
duplicate post. No replies, please.
Continue here
January 19, 2011 at 11:18 am
Joy Smith San (1/19/2011)
...I have written a query to get the same result in my own way.
Would like to see if there's a better way.
...
Please post what you've tried so...
January 19, 2011 at 5:28 am
Please read the first article referenced in my signature on how to describe the issue more detailed and with ready to use sample data.
It will be much more helpful if...
January 19, 2011 at 5:19 am
Do you still use the XML variable?
If so, you might want o try loading the data into a table with an ID column (being the clustered index) and add an...
January 18, 2011 at 4:12 pm
Nicky Murphy (1/18/2011)
Very neat!Is there a way of grouping by other intervals e.g. a week or a month?
Yes.
Just change GROUP BY DATEADD(DAY, DATEDIFF(DAY, 0, TIMESTAMP), 0) to the range you...
January 18, 2011 at 4:05 pm
Viewing 15 posts - 2,056 through 2,070 (of 5,502 total)