Forum Replies Created

Viewing 15 posts - 46 through 60 (of 1,182 total)

  • RE: Data mapping & migration tool

    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...

  • RE: Data mapping & migration tool

    Let me know if this works for you. 🙂

  • RE: Data mapping & migration tool

    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....

  • RE: SSRS Re-Ordering My ata

    SET DATEFIRST to 1, then include DATEPART(weekday,r.timesent) in your results set, then order by that.

  • RE: rewrite two queries to single query

    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...

  • RE: rewrite two queries to single query

    Sean Lange (6/19/2014)


    It looks like the only difference is that the first query will have consys.ParentLevelId = 5 and the second one 6? Just adjust your join condition slightly.

    SELECT DISTINCT...

  • RE: rewrite two queries to single query

    Why not use a UNION .. ?

    SELECT

    C.SubSystemID ,

    c.SubSystemName ,

    consys.SystemID ,

    conSys.SystemDisplayName ,

    ...

  • RE: Storing range of varchar values into variable for future filtering in query

    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

  • RE: Reporting Services Subscription problem

    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...

  • RE: Compare database across servers

    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...

  • RE: Compare database across servers

    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...

  • RE: Create MERGE statements with data!

    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...

  • RE: Data Driven Subscriptions

    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...

  • RE: Data Driven Subscriptions

    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...

  • RE: Data driven schedule with Reporting Services subscribed report

    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...

Viewing 15 posts - 46 through 60 (of 1,182 total)