Viewing 15 posts - 1,501 through 1,515 (of 2,007 total)
Hello and welcome to SSC!
It seems that your DDL script seems to have become detached from your post, or perhaps you were unaware of the benefits of providing one.
When...
September 27, 2011 at 9:12 am
Charlottecb (9/27/2011)
Thanks for your help.
No problem, glad you're satisfied!
I see you're obviously too busy to provide DDL and sample data as per this article[/url]. It's a shame, because I'm sure...
September 27, 2011 at 8:43 am
pjsweat (9/27/2011)
text column into a seperate field -
'Your item was delivered at 12:59 PM on 08/10/2011 in MARTINEZ,CA...
September 27, 2011 at 8:12 am
calvo (9/27/2011)
Cadavre (9/27/2011)
calvo (9/27/2011)
Have you checked that link? There's all the date conversions and date manipulations you'll ever need there.
DATEADD(YEAR,-2,cast(CURRENT_TIMESTAMP as DATE))
Just to prove that I do listen when I'm...
September 27, 2011 at 6:38 am
calvo (9/27/2011)
Have you checked that link? There's all the date conversions and date manipulations you'll ever need there.
DATEADD(YEAR,-2,cast(CURRENT_TIMESTAMP as DATE))
Just to prove that I do listen when I'm taught something...
September 27, 2011 at 6:19 am
Express12 (9/27/2011)
thank you.. now, how might I modify the above solution:SELECT DATEADD(YEAR,-2,CURRENT_TIMESTAMP)
to render a TIME = all 0's
SELECT DATEADD(dd, DATEDIFF(dd,0,DATEADD(YEAR,-2,GETDATE())), 0)
--Equivalent
SELECT DATEADD(dd, DATEDIFF(dd,0,GETDATE()) -730, 0)
But it's really no better than...
September 27, 2011 at 6:07 am
Express12 (9/27/2011)
SELECT DATEADD(dd, DATEDIFF(dd,0,GETDATE()) -730, 0)
How can I modify the above statement to use the YEAR instead of dd -- to obtain same result?
(eg......
September 27, 2011 at 6:03 am
p.stevens76 (9/27/2011)
If there is anything else you require please let me know.many Thanks in adavance
I'll try again, obviously I wasn't clear.
Thankyou for your very helpful DDL script! But unfortunately,...
September 27, 2011 at 3:53 am
grahamrd (9/26/2011)
Your query is work very good and it's did what i want thank you very much:kiss:
I went to many forums spent about ten days but I can...
September 27, 2011 at 3:46 am
Charlottecb (9/27/2011)
I'm having a problem constructing a SQL Server 2008 stored procedure and any help would be gratefully received...
A bit of background info...
I have a list of contractors doing...
September 27, 2011 at 3:43 am
OK, I know we've had this discussion before 😉
If you post readily consumable data and DDL scripts, then people will fall over themselves attempting to help. If you post a...
September 27, 2011 at 2:44 am
If you can supply us with suitable test data, I'm sure this can be solved in a nice set-based approach.
All I've done below is reformatted your code a little, to...
September 26, 2011 at 10:23 am
duggal.priyanka06 (9/26/2011)
September 26, 2011 at 3:41 am
grahamrd (9/24/2011)
Thank You very much for quick reply.
Yes I have change EXTENDEDDESCRIPTION (NVARCHAR(MAX) USING SQL Server Management Studio
Now I need to copy all the value from DESCRIPTION(nvarchar) column...
September 26, 2011 at 3:03 am
Good morning and welcome to SSC!
It seems that your DDL script seems to have become detached from your post, or perhaps you were unaware of the benefits of providing...
September 26, 2011 at 2:49 am
Viewing 15 posts - 1,501 through 1,515 (of 2,007 total)