Forum Replies Created

Viewing 15 posts - 391 through 405 (of 761 total)

  • RE: How to insert the records by group

    Please have a look at the link in my signature and post sample data as shown in it. People will find it a lot easier to work on your requirement...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 23, 2012 at 11:34 pm

    #1492260

  • RE: query for seeing the predefined table query

    shubhamagrawal.107 (5/23/2012)

    actually, i created a table before some time and now i want to see what query i used to create that table.

    now tell me can i see the...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 23, 2012 at 3:06 am

    #1491625

  • RE: How to Tune Performane of Stored Procedure

    Div Goud (5/23/2012)

    hi,

    how to tune the performance of a stored procedure.

    Depends on the Stored Procedure that you are talking about. But, generally there are a few things you need to...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 23, 2012 at 2:48 am

    #1491620

  • RE: How to Select Row to Column

    I could have been more precise if you had given me some sample data to work with.

    Anyways, you can accomplish what you are trying to do by using UNPIVOT. Here...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 22, 2012 at 11:43 pm

    #1491546

  • RE: how to write a select query with out passing parameter for this tables ?

    sivag (5/22/2012)

    thanks a lot Gullimeel and Vinu Vijayan

    You're welcome!! 🙂

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 22, 2012 at 4:29 am

    #1490962

  • RE: TRANSACTION ISOLATION LEVEL

    mah_j (5/22/2012)

    Thank alot vinu512 for you help:-)

    You're Welcome. 🙂

    I'm glad, I could help.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 22, 2012 at 1:32 am

    #1490880

  • RE: Data Islands and Gaps - How To

    Look at the very data you've presented. Where is 6:07 and has more than 10 minutes gone by since 6:00 with the levels indicated? I think not. The final answer...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 22, 2012 at 1:01 am

    #1490864

  • RE: Data Islands and Gaps - How To

    Doesn't it still work Mr. Jeff Moden??....The CTE give the following result set:

    InterfaceName TheDateTime ...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 22, 2012 at 12:47 am

    #1490857

  • RE: Data Islands and Gaps - How To

    dwain.c (5/21/2012)

    vinu512 (5/21/2012)

    Nice!!

    Very nice work with the Ordering Dwain. 🙂

    Thank you sir! I did enjoy that one.

    I couldn't think of it the way you thought.....its a good trick and...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 22, 2012 at 12:21 am

    #1490845

  • RE: Query help

    I think you can get it by Count() Over Partition as follows:

    --Creating Table

    Create table StoreGroup (

    StoreGroup int,

    Store int

    )

    --Inserting Sample Data

    insert into StoreGroup values

    (1,1),

    (1,2),

    (1,3),

    (2,4),

    (2,5),

    (2,6),

    (3,7),

    (3,2),

    (3,8),

    (4,1)

    --Query For Your Requirement

    Select StoreGroup, Store From

    (Select *,...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 22, 2012 at 12:20 am

    #1490844

  • RE: Data Islands and Gaps - How To

    dwain.c (5/21/2012)

    I'm not sure exactly if this fits the definition of islands and gaps because you seem to have complete data for each minute of time interval.

    This approach should work...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 21, 2012 at 11:54 pm

    #1490838

  • RE: TRANSACTION ISOLATION LEVEL

    mah_j (5/21/2012)

    HI

    what is the difference between Snapshot Isolation Level and Read Committed Snapshot?

    Both of them create their own snapshot of the data being read at that time.

    This link on...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 21, 2012 at 11:32 pm

    #1490831

  • RE: how to write a select query with out passing parameter for this tables ?

    sivag (5/21/2012)

    hi

    Gullimeel

    our query was working fine but if want to

    get the out put like this mean what...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 21, 2012 at 11:21 pm

    #1490822

  • RE: TO manage mutiple connections

    Yes, I agree with Steve....you need to use Dynamic SQL for this as follows:

    Declare @name1 varchar(max) = 'abhi.Test.dbo', @name2 varchar(50) =

    ...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 21, 2012 at 11:07 pm

    #1490817

  • RE: Error: 18456, Severity: 14, State: 5.

    David Webb-200187 (5/21/2012)

    If it's happening every minute, I'd be willing to bet someone has a SQL Agent job set up to check something on a dev server every minute and...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 21, 2012 at 10:50 pm

    #1490812

Viewing 15 posts - 391 through 405 (of 761 total)