Viewing 15 posts - 226 through 240 (of 3,232 total)
Great. You may also want to consider adding an index on the location column to prevent table scans.
November 23, 2010 at 12:17 pm
This is not returning results because your IN and your LIKE conditions conflict with each other. It looks to me, without seeing sample data, that you just need to...
November 23, 2010 at 9:47 am
1) Theres probably more reasons why you wouldn't want it to work this way than there are for working this way. Here are a few....
-- Dependancy checking in SPs...
November 22, 2010 at 12:17 pm
crookj (11/22/2010)
WOTD - turduckenJoe
Never had one.....heard they're fantastic.
November 22, 2010 at 9:46 am
ChrisM@home (11/20/2010)
Meat and chillies, no beans.
Onions, garlic, whole cumin seeds browned with the meat. Red chillies for colour, green for flavour. Cumin powder with the crushed tomatoes. Rich stock...
November 21, 2010 at 9:15 pm
Rob Schripsema (11/18/2010)
John Rowan (11/18/2010)
I'm sure there are more pros/cons that I listed here in a quick minutes, but that's the main area I can think of. Todd's method...
November 18, 2010 at 1:01 pm
Rob,
The method you've described will not allow for multi-threading the process. You will not be able to achieve multi-threading from within one package as you've described because the...
November 18, 2010 at 11:12 am
Good job Wayne....you beat me to it. I know a cte could do the trick, I was just working through the update logic.
Great solution!
November 17, 2010 at 2:28 pm
Dick Herberts-320552 (11/17/2010)
I would say , run the script and see yourself.
That would be great if I had a SS2008 instance to run it on. This fails on SS2005....
November 17, 2010 at 12:43 pm
What's with the binary dates?
November 17, 2010 at 12:12 pm
First thing is that you are missing 2 arguements in your NULL(DT_STR) element. The format for this should be NULL(DT_STR, <<Length>>, <<Code Page>>).
Second. What is the...
November 17, 2010 at 10:01 am
In addition to what Joe has posted, please refer to the article in my signature line for assistance on creating a post with proper examples and sample data. Following...
November 16, 2010 at 10:22 am
A simple GROUP BY will do the trick....
DECLARE @Table TABLE (Inventory int, Product varchar(10))
INSERT INTO @Table
SELECT 12345, 'ABC' UNION ALL
SELECT 12346, 'ABC' UNION ALL
SELECT 12347, 'ABC' UNION ALL
SELECT 12348, 'ABC'...
November 16, 2010 at 10:18 am
1. The only way you'll be able to make a generic script that can work for any table is to use dynamic SQL. Here's a good reference for...
November 16, 2010 at 10:06 am
Viewing 15 posts - 226 through 240 (of 3,232 total)