Viewing 15 posts - 946 through 960 (of 10,144 total)
I am running SQL Server Management Studio (version 2008 R2) on Windows 7 (64...
January 27, 2017 at 7:49 am
Focus first on ensuring that your existing query is correct. Comment out
s.SALESDESCRIPTION
January 27, 2017 at 7:35 am
Twice in the same day 🙂 Try this thread.
January 27, 2017 at 7:01 am
USE [Quartz]
GO
/******...
January 27, 2017 at 6:51 am
January 27, 2017 at 6:31 am
If dtDateTime is a datetime field then it's stored internally as a number - but displays according to local settings. Are you absolutely sure it's a datetime? If it is,...
January 27, 2017 at 6:12 am
It looks like it's not a space in the middle then...it's a different character.
Put this
SELECT
January 27, 2017 at 6:09 am
Thanks Eddie. Have a play with this. Order by the two prices, ascending and descending, and do a "stare and compare" - you're looking for values which won't convert to...
January 27, 2017 at 5:45 am
January 27, 2017 at 4:12 am
January 27, 2017 at 3:01 am
Msg 241, Level 16, State 1, Line 44
Conversion failed when converting date and/or time from character string.
January 26, 2017 at 7:45 am
Deny Christian - Thursday, January 19, 2017 12:28 PMComments posted to this topic are about the item Count Year,Month,Day
Did you try...
January 26, 2017 at 7:36 am
I have a function where i have to check column not null
if @sen like 'BY%'...
January 25, 2017 at 2:00 am
Viewing 15 posts - 946 through 960 (of 10,144 total)