Viewing 15 posts - 1,846 through 1,860 (of 3,232 total)
Thanks. Your example is different that what I thought you were after. I was thinking that you wanted to split the data differently as in 1/2 of the...
March 26, 2008 at 9:53 am
OK, we're getting there. Now, what would you like TableB and TableC to look like based off of the sample data you've provided for tableA?
TableB
????
TableC
????
March 26, 2008 at 9:24 am
What you are asking for does not make sense. If you are going to put half of TableA's rows into TableB and half into TableC, what is with TableB's...
March 26, 2008 at 8:57 am
Did you read the link? What I want is in my post. I want you to mock up an example that we can work with. Help us...
March 26, 2008 at 8:55 am
John is right. If you are going to scale your original query out to gather data from multiple tables as such, a UNION is probably the best way to...
March 26, 2008 at 8:41 am
This sounds pretty simple, but you'll need to provide more information to get good help on this one. How about some table DDL and sample data. Better yet,...
March 26, 2008 at 8:37 am
I'm not sure I fully understand what you are after here, but here's a go using Kent's sample data:
SELECT f1.*
FROM @Fruit f1
LEFT JOIN...
March 25, 2008 at 4:37 pm
Yes, use derived tables. It's hard to give you a good example without knowing more of your situation. If you need more help, post more info. on your...
March 25, 2008 at 4:20 pm
This sounds pretty simple, but you'll need to provide more information to get good help on this one. How about some table DDL and sample data. Better yet,...
March 25, 2008 at 4:17 pm
An average disk queue length of 50-60 tells me that you have an I/O bottleneck. The danger of using a SAN for DB storage is that the storage admins...
March 21, 2008 at 11:22 am
This may help: http://www.sqlservercentral.com/articles/Administering/customlogshipping/1201/. I've implemented a variation of this and it has been working for about 1 year with very little intervention/maintenance.
March 20, 2008 at 12:56 pm
Thanks for the follow up. Glad to hear you've figured it out. Check to make sure that the autoshrink property is not enabled.
March 20, 2008 at 9:47 am
Check your exectution plan on this one and watch your indexes. Using LIKE with a leading wildcard will result in a table scan if you're not careful. From...
March 20, 2008 at 8:56 am
I hope that helps, but like John M. said, your description is a bit confusing so my reply was kind of a stab in the dark at what you wanted....
March 20, 2008 at 8:51 am
Well, I can't tell from your description what type of join you need so you'll have to do that part but this should get you what you want. My...
March 20, 2008 at 8:43 am
Viewing 15 posts - 1,846 through 1,860 (of 3,232 total)