Viewing 15 posts - 1,771 through 1,785 (of 2,894 total)
It's possible to do what you're asking in T-SQL ETL without loop (cursor), but you need to implement all validations!
Basically the idea:
Apply validation rules for all rows in your "source"...
April 3, 2012 at 9:00 am
Yes you can. You will need to use dynamic SQL (search for "dynamic cross-tab".
However, if the number of columns does vary, you better to do so in a client/server tier...
March 30, 2012 at 7:01 am
Try:
UPDATE STATISTICS TableA
SELECT *
FROM (
Select FieldA, FieldB
From TableA
...
March 30, 2012 at 6:54 am
...
Another idea is that I add a computed column to the OrderDate table which is Cast(OrderDate as Date) and then index it. I could then join the calendar table directly...
March 30, 2012 at 6:36 am
Just an idea:
The standard process would be price lookup, then simple calculation.
Then I would have deal table, which would keep deals per product and quantity, please note: buy-one-get-one-free is not...
March 30, 2012 at 6:32 am
Thank you all for defending me...
Sorry, I wasn't right. I didn't read all posts through, what I've seen was just the first one, asking to sum HH:MM's and continues...
March 29, 2012 at 7:49 am
Just looking into this thread again...
What I can say, crap data structure design quickly leads to crap and stupid coding you need to do to achieve something good!
Calculating...
March 29, 2012 at 4:13 am
...so let's say you did not mean to imply you would do a round trip to the database to get said GUIDs
...
Without "so let's say...". I didn't say anything which...
March 28, 2012 at 10:41 am
You still never answered the question. You said earlier you would do a round trip for purposes of caching a bunch of GUIDs:
Where I've said that?
Even, with using GUID's,...
March 28, 2012 at 2:41 am
You had missing brackets (and wildcard %) in your WHERE clause - in place where you check for FirstName or LastName:
...
WHERE dpr.AgentID = @TempVQAgentID AND dpr.StateID = @TempVQStateID
AND (((@TempVQAppFName <>...
March 28, 2012 at 2:20 am
Jeff Moden (3/27/2012)
Eugene Elutin (3/27/2012)
...
Try adding this into the original sample data
SELECT 'Jun 1 2011 12:00AM','1','10','20' UNION ALL
The results of the two queries are different.
My query will only ...
March 28, 2012 at 2:12 am
MyDoggieJessie (3/27/2012)
Can anyone offer a solution to this issue regarding my post:: Yesterday @ 9:50 AM?
Can you provide DDL for UDF not as attachment? Not everyone want to download...
March 27, 2012 at 10:48 am
To Original OP ;-):
I'm not sure why I've done so, but here we are...
Please note the code formatting: it makes it much more readable therefore better maintainable...
CREATE PROCEDURE [dbo].[StoreProcedureName] (@StartDate...
March 27, 2012 at 10:45 am
Could you please post DDL and some data sample as per http://www.sqlservercentral.com/articles/Best+Practices/61537/
What exact output you watt to see?
How large your tables are?
March 27, 2012 at 9:46 am
Viewing 15 posts - 1,771 through 1,785 (of 2,894 total)