Viewing 15 posts - 1,171 through 1,185 (of 2,007 total)
Revenant (12/9/2011)
Ninja's_RGR'us (12/9/2011)
Dev (12/9/2011)
crookj (12/9/2011)
WOTD - RecursiveLoop
Sounds about right 😀
As long as it is not infinite
I tried to make it infinite, but the person that posted after...
December 9, 2011 at 9:05 am
GilaMonster (12/9/2011)
Cadavre (12/9/2011)
Shows that Kiara's assessment is correct, so is there another reason it fails?
CHAR(1). Concatenate '%' to a char(1) that holds 'A' and it gets silently dropped. So that...
December 9, 2011 at 9:00 am
Kiara (12/9/2011)
GilaMonster (12/9/2011)
Kiara (12/9/2011)
Oh, I dunno... Maybe the fact that Zyl sorts *after* Z%? 😛 Been there, written that, laughed at myself afterwards... 🙂No, that's actually not it...
I'm...
December 9, 2011 at 8:55 am
ChrisM@Work (12/9/2011)
Although it's less elegant than Cadavre's code, it's likely to perform a little faster.
Agreed 100%. Generally I use cross-tab queries to pivot data, I showed the syntax for PIVOT...
December 9, 2011 at 8:46 am
GilaMonster (12/9/2011)
Kiara (12/9/2011)
Oh, I dunno... Maybe the fact that Zyl sorts *after* Z%? 😛 Been there, written that, laughed at myself afterwards... 🙂No, that's actually not it...
Really? That's...
December 9, 2011 at 8:43 am
Dev (12/9/2011)
crookj (12/9/2011)
WOTD - RecursiveLoop
Recursive
December 9, 2011 at 8:33 am
BEGIN TRAN
--Sample data
SELECT ListingID, FileName, Priority
INTO #listing
FROM (SELECT 77, '00608192754sm.jpg', 1
UNION ALL SELECT 77, '00608192820sm.jpg', 2
UNION ALL SELECT...
December 9, 2011 at 8:30 am
Don't look exclusively for DBA jobs, include "Developer" and "Support" for SQL Server in your searches.
Most employers that are aware that DBA is a job with a narrow scope requiring...
December 9, 2011 at 8:20 am
WangcChiKaBastar (12/9/2011)
Thanks, I think I need the date as well.so I will need '2011-12-09 09:50' from 2011-12-09 09:50:34.600
in SQL Server 2005.
You posted in the SQL Server 2008 forum.
DECLARE @DATE AS...
December 9, 2011 at 8:06 am
WangcChiKaBastar (12/9/2011)
How can I select only Hour and Minute from datetime without any seconds part.I need only 09:43 from ' 2011-12-09 09:43:36.743 '
SELECT CONVERT(TIME,'2011-12-09 09:43:36.743')
December 9, 2011 at 7:47 am
prashant-507002 (12/9/2011)
I think i have to post support ticket to microsoft for the same.
Who will tell you that you need to restore your database somewhere, then copy the data back...
December 9, 2011 at 7:22 am
Again : -
DECLARE @sql AS VARCHAR(MAX)
SELECT @sql = COALESCE(@SQL, '') + 'MAX(CASE WHEN [strFieldCaptionName] = ''' + [strFieldCaptionName] + ''' THEN [strFieldValue] ELSE NULL END) AS ''' + [strFieldCaptionName] +...
December 9, 2011 at 7:19 am
Lowell (12/9/2011)
Second Place...again 😉WTG Cadavre.
...
December 9, 2011 at 7:13 am
adonetok (12/9/2011)
How to run a script to update all 01/01/1900 to null in a date type column?
Ummm. . .
UPDATE myTable
SET myDate = NULL
WHERE myDate = '1900-01-01'
December 9, 2011 at 7:06 am
Ninja's_RGR'us (12/9/2011)
prashant-507002 (12/9/2011)
Restore database is one option but we have no rights for that and also it data centre server and they charge for space
You can restore to your...
December 9, 2011 at 7:01 am
Viewing 15 posts - 1,171 through 1,185 (of 2,007 total)