Viewing 15 posts - 58,021 through 58,035 (of 59,054 total)
Here's another way to find what the day of the week is without regard to @@DateFirst...
SELECT DATENAME(dw,GETDATE())
July 6, 2006 at 6:37 am
Or, you could do this...
SET @variable = ISNULL(@variable,0)
... for inline code, you don't even need to change the value... just use the formula...
SELECT ISNULL(@variable,0)
FROM yada yada
... OR...
SELECT yada yada
FROM wgga...
July 6, 2006 at 6:30 am
Thank you for the feed back on your resolution! It's a keeper... ![]()
July 5, 2006 at 10:29 pm
>Shouldn't need to index the view if the underlying tables are properly indexed Well that... |
July 5, 2006 at 9:58 pm
Shouldn't need to index the view if the underlying tables are properly indexed... indexing a view also requires the view to be schema bound and that all UDF's addressed by...
July 4, 2006 at 10:51 pm
Guess I'm being a bit picky here... where does @a or @b-2 parameters of the function get used in the function? I'm thinking the function posted has some other problems......
July 4, 2006 at 10:34 pm
| Nowhere is the hardware/disksubsystem described |
If his server has less horsepower than my desktop (P4, 1.8Ghz, @MB Ram,...
July 4, 2006 at 10:22 pm
I guess the real question to Josh would be... why is this needed in a single string?
July 4, 2006 at 10:15 pm
5 million records should take 5 minutes or less for BCP and even faster for BULK INSERT (it does less data checking). Changing the batch size to 20000 will help get...
July 3, 2006 at 4:23 pm
Probably... but I wouldn't... have you ever worked with a TEXT datatype before? It's a pain in the sitting-muscles. I'd likely setup some table with the results of the different...
July 3, 2006 at 4:08 pm
There's a fair amount of info in Books Online about "bitwise" operators, the bit data type, using powers of two, etc. Not sure what you're looking for or what your...
July 3, 2006 at 4:03 pm
Great... and simple, too...
When you create a table, create your "sequential ID" column with the IDENTITY property...
For example... this will create a table, insert 3 rows, insert 3 more rows,...
July 3, 2006 at 3:39 pm
Like you said, the code has been running fine except for the occasional hiccup... the problem must be in the data somewhere you are not trapping for an error.
July 3, 2006 at 3:24 pm
Keith and Farrell,
Thank you both for your feedback... My bad... the usage should be like this...
SELECT DISTINCT Name,
dbo.ConcatStatus(Name) AS StatusList
FROM yourtable
July 3, 2006 at 3:05 pm
Viewing 15 posts - 58,021 through 58,035 (of 59,054 total)