Viewing 15 posts - 4,726 through 4,740 (of 5,502 total)
You need to add the namespace definition before your query:
;WITH XMLNAMESPACES (
yournamespace 'your namespacefiles'
)
SELECT
If you have problems getting it to work, please post the few...
November 24, 2009 at 11:14 am
We do it pretty much the same with just a little difference:
Instead of having three tables like Lowells solution has, we're using one table with positive values for received /...
November 23, 2009 at 3:44 am
It looks like either your result set does not match your requirement or your requirement is still unclear...
Example:
companynamedistrictnamestorenbrbusinessdateMatureMathAudioBooks
OnlineDotComHuntsville00052009-09-07 00:00:00.00017521752360
OnlineDotComHuntsville00052009-09-07 00:00:00.00023882388519
OnlineDotComHuntsville00052009-09-07 00:00:00.00019931993379
It shows that there is more than one row for...
November 22, 2009 at 11:29 am
This common requirement usually can be resolved using a calendar table.
Search this site for "calendar table" and you'll find a variety of solutions and discussions related to it.
If you have...
November 21, 2009 at 1:45 pm
If I understand correctly you want to have the rollup result value before the values rolled up as opposed to the SQL standard.
The closest I could come up with is...
November 21, 2009 at 1:32 pm
One possible reason for not having an answer yet might be your rather large xml together with a missing result set to compare to.
Try to reduce your sample xml to...
November 21, 2009 at 7:43 am
Please can you help me out.
Is it possible to Group By an Alias column name?
Simple answer: Yes and no. 😉
Yes, if you would wrap your query into a subquery or...
November 21, 2009 at 6:06 am
I thought about providing some sample code for a set based solution, too. But since I couldn't find any place in the code where the OP used the variable @entrydateconv...
November 20, 2009 at 3:04 pm
A few things to notice:
1) (regarding your question)
The problem is with @entrydateconv = DATEADD(day,-29,getdate()) .
Since you "normalized" @entrydateconv, your WHERE condition will only be true exactly at midnight for each...
November 20, 2009 at 1:43 pm
Hi Nabha,
I'll stop guessing and step back until I see some expected results (now that you've done the first part of providing sample data 😉 ).
November 20, 2009 at 7:13 am
It sounds like a job for Service Broker.
It's a little bit tough to get it started, but once it's runnning, it's running...
November 20, 2009 at 5:49 am
If the following won't give you the expected result you need to follow Nabha's advice and give us something to test against.
For details on how to post sample data please...
November 20, 2009 at 5:32 am
You could have a look at the following articles referenced in my signature: CrossTab or Dynamic Cross Tab (if DataSrc contains an unknown list of elements).
I assume you're using SQL2000...
November 19, 2009 at 2:28 pm
Would it be possible for you to wrap the columns using a string character e.g. " ' "?
Sample data:
CREATE TABLE csv(id int, data varchar(30))
INSERT INTO csv
SELECT 1, 'single value: a'...
November 19, 2009 at 2:22 pm
Or you could replace [pprice] with its original calculated fields (please note that I change your query in terms of ISNULL usage):
select productname, (uprice+sprice) As pprice, IsNull(uprice+sprice,0) As pprice2
from...
November 19, 2009 at 12:10 pm
Viewing 15 posts - 4,726 through 4,740 (of 5,502 total)