Viewing 15 posts - 46 through 60 (of 1,183 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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 23, 2014 at 1:07 pm
Let me know if this works for you. 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 23, 2014 at 7:16 am
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....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 22, 2014 at 12:38 pm
SET DATEFIRST to 1, then include DATEPART(weekday,r.timesent) in your results set, then order by that.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 19, 2014 at 7:49 am
Sean Lange (6/19/2014)
SELECT DISTINCT...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 19, 2014 at 7:39 am
Why not use a UNION .. ?
SELECT
C.SubSystemID ,
c.SubSystemName ,
consys.SystemID ,
conSys.SystemDisplayName ,
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 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
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 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/%5B/url%5D
Hi Jason
I'm trying out...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 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/%5B/url%5D
Hi Jason
I'm trying out your code using...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 28, 2014 at 4:06 pm
Viewing 15 posts - 46 through 60 (of 1,183 total)