Forum Replies Created

Viewing 15 posts - 586 through 600 (of 761 total)

  • RE: Stuff 0's between 2 int values

    This is a workaround to your requirement:

    declare @a varchar(10), @b varchar(10), @c varchar(10), @d varchar(10) = '00'

    set @a='1'

    set @b='2'

    Set @c=+@a+@d+@b

    Select @c

    set @a=112

    set @b=2

    Set @c=+@a+@d+@b

    Select @c

    Hope this helps.

    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] 😉

    April 27, 2012 at 12:29 am

    #1480201

  • RE: Create a database from a SQL Server 2000 .bak file

    +1

    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] 😉

    April 27, 2012 at 12:16 am

    #1480196

  • RE: SQL Server 2008 R2 Download Issue

    Which edition did you download?

    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] 😉

    April 27, 2012 at 12:14 am

    #1480194

  • RE: subquery Q?

    Try running the below mentioned query as a single query:

    select s.Itemid from #sequence s join #item i on s.Itemid=i.Itemid

    I think this must be returning more than one "Itemid". If that...

    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] 😉

    April 27, 2012 at 12:10 am

    #1480192

  • RE: return multiple columns based on single CASE evaluation

    There are a lot of people who can help you here. For that please post DDL, sample data and an example result set of what you are expecting so that...

    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] 😉

    April 26, 2012 at 11:21 pm

    #1480186

  • RE: insert into table variable

    Yes you can do that...if the SP does what you are asking it to do

    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] 😉

    April 26, 2012 at 11:15 pm

    #1480185

  • RE: Multiple Part Descriptions

    Lynn Pettis (4/26/2012)

    dwain.c (4/26/2012)

    I was looking at a stock table with the columns Part Number and Part Description. I just found out that we have over 95 tables that contain...

    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] 😉

    April 26, 2012 at 11:11 pm

    #1480184

  • RE: SSMS getting confused

    hmm...yes...could be...that's very logical Jared.

    A very good shot in the dark. 🙂

    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] 😉

    April 26, 2012 at 10:54 pm

    #1480182

  • RE: sp_refreshview

    sqlfriends (4/26/2012)

    I am using red gate SQL compare tool.

    I did a comparison that generats delta schema script.

    I see there are some statements like :

    EXEC sp_refreshview [Tests].[BusinessReport]

    My question is when 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] 😉

    April 26, 2012 at 10:51 pm

    #1480181

  • RE: Replacement for Cursors

    Jeff Moden (4/26/2012)

    vinu512 (4/25/2012)

    OK...my bad...lets forget about printing the names.

    I just want the names to be stored in 5 temp variables so that I can use them further.

    Can that be...

    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] 😉

    April 26, 2012 at 10:34 pm

    #1480178

  • RE: Unable to connect to SQL Server 2008 r2 named instance

    jmiceli (4/26/2012)

    I am not trying to hijack this thread; I am just making this information available to any interested parties.

    We have this same structure except that the 2005 named instance...

    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] 😉

    April 26, 2012 at 10:18 pm

    #1480173

  • RE: Foreach in Creating a View

    brally123 (4/26/2012)

    @vinu512

    Thanks for the answer, but I already followed Cadavre's method.

    Again, thanks for helping! 🙂

    Regarding the points i mentioned, it's the points[score] under your name. :;-)

    No problem.

    ALways happy to 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] 😉

    April 26, 2012 at 10:13 pm

    #1480171

  • RE: txt import

    What method did you use to import the Data??..."DTS Wizard" or you did it by creating a Job through "BID Studio"?

    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] 😉

    April 26, 2012 at 10:08 pm

    #1480170

  • RE: can i use replication ? what is your idea?

    Larry Page(Ehsan.Akbar) (4/26/2012)

    what about update?

    You need performance...right??

    The best performance you can get is by getting all the data on 1 server and then perform whatever actions you want to perform...

    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] 😉

    April 26, 2012 at 10:06 pm

    #1480168

  • RE: can i use replication ? what is your idea?

    Larry Page(Ehsan.Akbar) (4/26/2012)

    so actually i have 20000 records in my table ,so every second i have to execute a search query ,and this query returns 4 result each second ,

    Its...

    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] 😉

    April 26, 2012 at 7:01 am

    #1479672

Viewing 15 posts - 586 through 600 (of 761 total)