Viewing 15 posts - 53,731 through 53,745 (of 59,068 total)
Whether I agree with bit-masking in SQL Server or not, I enjoyed the article. Thanks.
December 5, 2007 at 5:01 pm
I'm looking for a way to check for a view or table and if it is there, do nothing, if it is not there create it. Typically there is the...
December 5, 2007 at 4:40 pm
Have you actually tried that and gotten it to work?
Besides, if you're gonna take the time to define a table variable, you might just skip that step and...
December 5, 2007 at 6:12 am
Right in the middle of the million rows is a record or two that is mangled. Rejecting the file isn't an option. The import routine needs to be able to...
December 5, 2007 at 6:09 am
Two way street here... HOW did you resolve it?
December 5, 2007 at 5:58 am
I'm a little worried about what will happen when several sources are using it at once while the deletes are running
Good to be worried about these types of things... try...
December 4, 2007 at 7:47 pm
Heh... graduates from "Micromanagement 101", I'm afraid... 😉
December 4, 2007 at 7:11 pm
[font="Courier New"]DECLARE @PostalAddress TABLE (StreetAddressTxt VARCHAR(100))
INSERT INTO @PostalAddress (StreetAddressTxt)
SELECT '123456\78910' UNION ALL
SELECT 'ABCDEFG\HIJKLM'
SELECT * FROM @PostalAddress
UPDATE @PostalAddress
SET StreetAddressTxt = SUBSTRING(...
December 4, 2007 at 7:02 pm
If you have a small file example (emphasis on "small"), attach it to a post and let's take a crack at it... 😉
December 4, 2007 at 6:03 pm
Cast to INT will get rid of leading zeros.
December 4, 2007 at 5:49 pm
Heh...
Step 1... search SysComments for the word "Cursor".
Step 2... search SysComments for the word WHILE
Step 3... search SysComments for the occurance of any view.
Step 4... review all User Defined...
December 4, 2007 at 5:44 pm
Interesting site with more than what I ever wanted to know... 😀
I did find some files to "play" with...
December 4, 2007 at 5:36 pm
Gosh... what's wrong with just...
EXEC master.dbo.xp_fixeddrives
December 4, 2007 at 5:14 pm
Heh... thanks for the feedback, Mark... and no problem...
Say, do you have the URL for that census data? Might be fun to play with... thanks.
December 4, 2007 at 5:09 pm
Viewing 15 posts - 53,731 through 53,745 (of 59,068 total)