Forum Replies Created

Viewing 15 posts - 511 through 525 (of 761 total)

  • RE: RS with two date columns from a single date column

    This might help:

    Select

    (Case When Tag = 'Tag1' Then Date else NULL end) As Tag1Date,

    (Case When Tag = 'Tag1' Then Value else NULL end) As Tag1Value,

    (Case When Tag...

    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 4, 2012 at 1:42 am

    #1483416

  • RE: Adding in Server to From statement on the fly

    I don't think you can do that without using Dynamic SQL. If you user the following code:

    Declare @Tablename1 varchar(30) = 'Test'

    Declare @Tablename2 varchar(30) = 'Test1'

    Select * From @tablename1 as u...

    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 4, 2012 at 12:58 am

    #1483410

  • RE: Hyperlink not working in sql server

    I don't know about the tool you are using....but you can do it easily by using either of the following in SQL Server:

    1. Import/Export Wizard

    2. Bulk Insert

    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 3, 2012 at 11:37 pm

    #1483402

  • RE: help with SQL query please

    capn.hector (5/3/2012)

    not a problem. when i do these sort of things i try to think of cases where my query would break. i almost posted exactly what you...

    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 3, 2012 at 6:45 am

    #1482966

  • RE: Link on DOT NET TECHNOLOGY

    pawan.boyina (5/3/2012)

    We are following sqlservercentral for all the updates on sqlserver, can a similar kind of DOT NET link be provided?

    List of .Net Forums

    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 3, 2012 at 5:27 am

    #1482923

  • RE: MAX - MIN SUM QUERY

    If imex's solution doesn't work then please post the DDL of your table and some readily consumable sample data to go with it.

    Help us in helping you.

    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 3, 2012 at 3:39 am

    #1482882

  • RE: help with SQL query please

    capn.hector (5/2/2012)

    vinu512 (5/1/2012)

    This does:

    SSelect * From ClientDetails

    Where InterviewDate IN (Select MAX(InterviewDate) From ClientDetails Group By ClientID)

    the problem with that query is the IN list contains the max interview date for...

    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 3, 2012 at 12:29 am

    #1482816

  • RE: Resolve Collation Conflict problem in T-SQL (SHUBHAM SAXENA)

    shubham.saxena67 (5/2/2012)

    Dear friend,

    plz tell me how to drop primary key 'IND_HIM8' on table City_Master CITY_ID Column..

    Plz send me Script to drop primary key..

    Thanks

    ALTER TABLE <table_name>

    DROP CONSTRAINT <Primarykey_name>

    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 2, 2012 at 4:20 am

    #1482265

  • RE: use pivot instead of alter table

    elham_azizi_62 (5/2/2012)

    I could download this zip file.please try again.thanks

    They are not saying that they could not download it.

    These are real people who take out time from their busy work schedules...

    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 2, 2012 at 3:02 am

    #1482245

  • RE: Move data from one table to another using sql

    Guvera (5/2/2012)

    Thanks. Its working fine now.

    What made it 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 2, 2012 at 2:36 am

    #1482234

  • RE: Domanin Error?

    al_yamama_1980 (5/2/2012)

    Vinu512 I looked some thing when i go to the firwell > allwo aprogram or featrue througe widows firewell>SQL server > details the messgae appaer there is { No...

    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 2, 2012 at 1:48 am

    #1482215

  • RE: Domanin Error?

    al_yamama_1980 (5/2/2012)

    I tray that but again nothing happaned

    I can't think of anything that might help you...May be the pros here might have something better for you.

    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 2, 2012 at 1:06 am

    #1482205

  • RE: Domanin Error?

    al_yamama_1980 (5/1/2012)

    Hi every one

    My windows server 2008 R2 and setyp SQl server 2008 when i went to coonect the ODBC the Messge appeare:

    Sql state :"01000"

    Sql server error:"11001"

    [Microsoft] [ODBC Sql server...

    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 2, 2012 at 12:59 am

    #1482203

  • RE: use pivot instead of alter table

    elham_azizi_62 (5/1/2012)

    Hi, these are scripts of my tables use in procedures and view.

    thanks for your replies.

    Thank you very much for posting the DDL Scripts.

    You would also have to post some...

    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 2, 2012 at 12:53 am

    #1482202

  • RE: Move data from one table to another using sql

    Guvera (5/2/2012)

    Hi,

    I am having two tables that table name Test1 & Test2. Two tables are same and Test2 is the backup table for Test1. Now i need to do some...

    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 2, 2012 at 12:39 am

    #1482200

Viewing 15 posts - 511 through 525 (of 761 total)