Viewing 15 posts - 1,846 through 1,860 (of 5,502 total)
See my reply in your original thread.
February 25, 2011 at 1:56 pm
There's no need to post in the 2000 forum in this case.
A cte is nothing but a subquery in this specific case.
You could use the following code insted:
SELECT ...
February 25, 2011 at 1:54 pm
Logic like this usually should be done at the presentation layer.
However, if you need to do it at the DB layer, you could use
;WITH cte AS
(
SELECT 1 AS pos,Code,DATA FROM...
February 25, 2011 at 12:24 pm
What exactly do you consider being a problem that needs to get resolved?
Based on your requirement
I have to join this one line with the results of all the remarks...
February 25, 2011 at 11:13 am
TheSQLGuru (2/25/2011)
And what is your preference when you notice that an index gets fragmented from 0% to say 90% after 24hrs? Do you reorganize it on a daily basis or...
February 25, 2011 at 11:04 am
Did you try to assign a default value to the @CloseDate parameter?
February 25, 2011 at 10:51 am
It doesn't look like a database issue. It seems more like an issue of the app sending the data to the DB.
Did you try to run the stored procedure that...
February 25, 2011 at 10:49 am
Sounds like homework.
Since most of us already have their degree we don't need to answer those questions anymore. 😉
But we'd be glad to help you understand how it works if...
February 25, 2011 at 10:32 am
Bhuvnesh (2/24/2011)
select * from
(
select
english as [john_english],
social as [john_social]
from @t where name = 'john') a
,
(select english as...
February 24, 2011 at 3:14 pm
Since you decided to double post, here's a copy of my reply, still awaiting your reply (on either thread).
LutzM (2/24/2011)
dont' you see some kind of a contradiction when reading the...
February 24, 2011 at 2:59 pm
David,
dont' you see some kind of a contradiction when reading the following two statements?
"I will be very much grateful if you can help solve this problem of mine."
vs.
"You are to...
February 24, 2011 at 2:52 pm
Have a look at the CrossTab and DynamicCrossTab articles referenced in my signature.
as a side note: Pivoting and the like usually should be done at the presentation layer, not at...
February 23, 2011 at 4:34 pm
jorge_gomes98,
please open a separate thread for the issue you're struggling with.
The section you posted in should be realated to the article. More related than "it's an xml issue"....
February 23, 2011 at 12:04 pm
My pleasure. 😀
But all the honor belongs to Jeff for posting this solution and continuously improving it.
As a side note: do you completely understand how it works and when you...
February 23, 2011 at 12:01 pm
please search this site for DelimitedSplit8K. It will point you to a function that will be much more efficient than your loop. The function mentioned above could be used as...
February 22, 2011 at 5:12 pm
Viewing 15 posts - 1,846 through 1,860 (of 5,502 total)