Viewing 15 posts - 20,926 through 20,940 (of 26,490 total)
punsaonline (5/19/2009)
I was just looking...
May 19, 2009 at 4:38 pm
Then why worry about rewriting it in a different format?
May 19, 2009 at 4:17 pm
Please post your query that uses this function.
May 19, 2009 at 4:15 pm
punsaonline (5/19/2009)
No i killed the query as it was taking lot of time
In your original post, you said the first query returned in seconds. Did it return the expected...
May 19, 2009 at 4:08 pm
punsaonline (5/19/2009)
My Query previously looks like that
Select A.A1,B.B2
FROM A_TABLE A
INNER JOIN B_TABLE B
ON A.A1 = B.B1
WHERE B.B2 = 'XYZ'
This query executed in seconds but when i changed this query to
Select...
May 19, 2009 at 3:57 pm
FYI, Books On-Line is your friend. You will find many of your answers thee.
May 19, 2009 at 8:48 am
If you need to work with this database on your computer you may want to consider spending $50.00 (USD) and buying the Developer Edition of SQL Server.
May 19, 2009 at 8:17 am
You indicated in your original post (I belieive) that you are using SQL Server Express? I don't think you will be able to access the database. The Express...
May 19, 2009 at 8:15 am
First, your data provided does not match the diagram.
Here is some code to play with:
create table dbo.bom (item_id int, item_name varchar(15), qty int, parent varchar(10),parent_id int, has_child int, primary key(item_id));
insert...
May 18, 2009 at 4:26 pm
I really expected that you'd have data for this year and last year as well. You do want to be able to compute the YTD and Previous YTD Sales...
May 18, 2009 at 3:23 pm
As i get started at looking at this, I just want to confirm you are using SQL Server 2000, not SQL Server 2005. I don't want to use any...
May 18, 2009 at 3:11 pm
Florian Reischl (5/18/2009)
Bob Hovious (5/18/2009)
Arrrgg! Flo, I just realized I never proofed your article!
No problem :-). Take the time you need or give me a short hint...
May 18, 2009 at 3:08 pm
Rem (5/18/2009)
Result: SP3Am I OK?
Simple answer. Yes.
Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2...
May 18, 2009 at 2:11 pm
The only other change I would make to Option #3 is to make the EndPeriod an "open end" on the range. Example:
StartPeriod ...
May 18, 2009 at 2:07 pm
Viewing 15 posts - 20,926 through 20,940 (of 26,490 total)