Viewing 5 posts - 16 through 20 (of 20 total)
Given that the DB_Name will be duplicate the above solution wont work.
You have to do something like this: In the future, please provide some testdata..
EDIT: Sorry, the above solution is...
April 19, 2012 at 2:45 am
Your Channels Table definition should be changed to be the same as Channels2:
[MAS90ID] [nvarchar](10) NULL,
[SLXID] [nvarchar](10) NULL,
Should be changed to:
[MAS90ID] [nvarchar](50) NULL,
[SLXID] [nvarchar](50) NULL,
EDIT : Gail beat me to it
April 17, 2012 at 10:27 am
Add the following to your CTE Where clause:
WHERE Revision_num IN(
SELECT MAX(Revision_num) FROM AllData
GROUP BY Ticket#)
April 16, 2012 at 2:35 pm
stevro (4/15/2012)
select * from MainVideo where CONVERT(date,datetime) = Convert(date,@VarDateTime,101)The additional 101paramater is the style, in this case US .
Look at http://msdn.microsoft.com/en-us/library/ms187928(v=sql.105).aspx for additional styles/
Correction I see it...
April 15, 2012 at 6:17 am
select * from MainVideo where CONVERT(date,datetime) = Convert(date,@VarDateTime,101)
The additional 101paramater is the style, in this case US .
Look at http://msdn.microsoft.com/en-us/library/ms187928(v=sql.105).aspx for additional styles/
April 15, 2012 at 6:14 am
Viewing 5 posts - 16 through 20 (of 20 total)