Viewing 15 posts - 46 through 60 (of 1,182 total)
That's going to be a bit more difficult since you're not comparing the column's datatype, but the actual data's datatype.
I'm not sure how you could go about that without dynamic...
June 23, 2014 at 1:07 pm
shivanath,
Today is your lucky day. 🙂 I wrote this several years ago to do the exact task you're looking for.
Using the datatype conversion grid found here : http://msdn.microsoft.com/en-us/library/ms187928.aspx
1....
June 22, 2014 at 12:38 pm
SET DATEFIRST to 1, then include DATEPART(weekday,r.timesent) in your results set, then order by that.
June 19, 2014 at 3:36 pm
Sean Lange (6/19/2014)
Jason Selburg (6/19/2014)
Sean, you missed the second query actually adds in the SubLocation table. 🙁
Ahh so I did. Then it seems the UNION query you posted would be...
June 19, 2014 at 7:49 am
Sean Lange (6/19/2014)
SELECT DISTINCT...
June 19, 2014 at 7:39 am
Why not use a UNION .. ?
SELECT
C.SubSystemID ,
c.SubSystemName ,
consys.SystemID ,
conSys.SystemDisplayName ,
...
June 19, 2014 at 7:35 am
One of many methods ....
DECLARE @OrderTypes TABLE
(OrderType CHAR(2))
INSERT @OrderTypes
VALUES ('10'),('15'),('18')
SELECT *
FROM SalesOrders AS SO
INNER JOIN @OrderTypes AS OT
ON SO.OrderType = SO.OrderType
June 17, 2014 at 1:23 pm
Does this help? I sounds like you are already doing something similar. I have had reports of needing to wait for a timeout. Now that I think of it, maybe...
June 1, 2014 at 6:51 pm
SQLRNNR (5/28/2014)
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
Another vote for the RedGate SQL Compare tools.Nice license plate Jason S.
Another vote for Red-Gate SQL Compare. There are a number of other options...
May 28, 2014 at 5:34 pm
smriti.subramanian (5/28/2014)
Hi,I want to compare the database structures(columns,datatypes..etc) across same databases located in different servers. Can you please let me know how we can achieve this?
Thanks in advance.
Red Gate has...
May 28, 2014 at 7:07 am
EDIT: In case this doesn't make it into the actual article, I wanted to clarify a few items.
1. The script has a few restricting conditions that you may want to...
May 28, 2014 at 6:51 am
ldanks (4/8/2014)
Jason Selburg (4/8/2014)
ldanks (4/8/2014)
Jason Selburg (5/16/2011)
This is the most recent code I have. It may need some tweaking for 2008, I've not tested it on '08.http://www.sqlservercentral.com/articles/Development/2824/[/url]
Hi Jason
I'm trying out...
April 8, 2014 at 3:55 pm
ldanks (4/8/2014)
Jason Selburg (5/16/2011)
This is the most recent code I have. It may need some tweaking for 2008, I've not tested it on '08.http://www.sqlservercentral.com/articles/Development/2824/[/url]
Hi Jason
I'm trying out your code using...
April 8, 2014 at 10:07 am
Check the article I referenced above.
Follow the instructions and create a subscription that will never run (set its run date to the past). It also explains how to get the...
January 28, 2014 at 4:06 pm
Viewing 15 posts - 46 through 60 (of 1,182 total)