Viewing 15 posts - 5,086 through 5,100 (of 5,590 total)
if you're making a new table:
select *
into DestinationTable
from SourceTable
where Expression
If the destination table already exists:
insert into DestinationTable
select *
from SourceTable
where Expression
where:
DestinationTable is...
July 4, 2009 at 9:13 am
And, just to be complete, I ran this test again including Lynn's CTE method (DelimitedSplit):
XML: 1571/1100/1350/1134/1130
Tally: 1429/1313/1306/1317/1288
CTE: 6283/6221/6292/6445/6569
July 3, 2009 at 10:09 pm
Okay, I pushed my tally table from 30,000 to 1,000,000 records (30,000 / (14 char acct# + comma)) = 2000..... 😀
I get these results when running the code in my...
July 3, 2009 at 9:54 pm
@jeff - would you mind trying out this little piece of code and let me know how fast it is on your "computer in a deathbox"?:-D
Also, would you compare the...
July 3, 2009 at 9:14 pm
lmu92 (7/3/2009)
Your example has two rows with 12 rsp 15 seconds.
How would you handle those?
a) add it up...
July 3, 2009 at 7:48 pm
First, I want to thank you for posting the DDL and DML for the test data.
Now, I have a question. What second are you looking for... elapsed, TranIn, or TranOut?
If...
July 3, 2009 at 3:28 pm
@Lynn - it looks like the beginning of your CTE is missing, and the select from it isn't referencing the CTE. Otherwise, very nicely done.
July 3, 2009 at 1:37 pm
GilaMonster (7/3/2009)
You laugh. I was speaking with someone recently and he said that he and his team do some SQL development, but nothing complex, no joins or anything.
chuckle...
Makes one wonder......
July 3, 2009 at 9:57 am
Be careful when using the Between operator with dates.
In your requirements, you basically are saying that your billing date starts promptly at 9am; everything prior to that is the previous...
July 3, 2009 at 6:24 am
only4mithunc (7/3/2009)
Ok.... any way once again thanks a lot...Regards
MC
I'm glad that we could help you.
July 3, 2009 at 6:08 am
John Marsh (7/2/2009)
You can find a definition of irony here: http://www.askoxford.com/concise_oed/irony?view=uk
You may like to spend your time writing code to duplicate logic already provided elsewhere but that does not...
July 3, 2009 at 5:59 am
If I remember correctly (and it's been a year since I did any SSRS), just remove the "(0)".
July 3, 2009 at 5:49 am
Dave Ballantyne (7/3/2009)
Generally i try to 'teach a man to fish'.But really, come on give it a try.....
http://www.sqlservercentral.com/Forums/Topic746875-49-1.aspx
Well Dave, it seems that you did help him. http://www.sqlservercentral.com/Forums/FindPost746898.aspx
July 3, 2009 at 5:47 am
Nag,
Yes, sp_msForEachDB is an undocumented system stored procedure. Which just means that google will have the information you need for how to use it.
What I find ironic is the suggestion...
July 2, 2009 at 9:39 pm
Viewing 15 posts - 5,086 through 5,100 (of 5,590 total)