Forum Replies Created

Viewing 15 posts - 211 through 225 (of 253 total)

  • RE: SQL Opportunities with EEI!

    Hello Frank

    I sent over an email with my resume. The email bounced back..is there any other email that you can be reached with ?

    Dinakar.

    April 26, 2005 at 8:27 pm

    #555079

  • RE: I need a replacement! (Chicago Suburbs)

    Hi Josh

    Is this a consulting position or a permanent one ? Also would the company sponsor visa (H1 B) ?

    I have a Masters from Louisiana State University and...

    April 26, 2005 at 8:23 pm

    #555078

  • RE: Conditional Formatting

    What do you mean by more than two ?

    April 26, 2005 at 3:27 pm

    #555059

  • RE: Invalid Insert Statement in the Function

    Cant believe I missed that..

    April 26, 2005 at 10:11 am

    #554955

  • RE: Invalid Insert Statement in the Function

    I think if you explicitly write out the column names you should be okay..
     
    insert into dbo.SB_InvoiceCostingService
       (col1, col2,......)
    values
       (@TotService,@TotParts,1,1,1,1,1,1)

    April 26, 2005 at 9:21 am

    #554930

  • RE: Headers,Footers and data

    I dont know about 2005 but we ended up moving the entire header section into the body part. That is the only work around IMHO.

    April 25, 2005 at 9:44 am

    #554632

  • RE: Why use triggers?

    Here's some info from BOL :

    Constraints and DML triggers each have benefits that make them useful in special situations. The primary benefit of DML triggers is that they can contain...

    April 25, 2005 at 9:00 am

    #554615

  • RE: Adding Identity to the existing table

    Like the msg says you cannot insert into an identity column.
     
    INSERT INTO yaf_Forum(col2,ol3,,...)

    SELECT col2,col3 FROM OLDForums...oldForum

     
    etc. your forumid value will automatically be filled with identity numbers.

    April 22, 2005 at 1:14 pm

    #554412

  • RE: MS Sql Reporting services and Group footer

    set up a group at the highest level and the group on expression would be "total" without the quotes and it will print at the end of all the records....

    April 22, 2005 at 10:38 am

    #554387

  • RE: delete where not exists

    DELETE  FROM

       Patient_Policies

    WHERE

       Patient_Policy_ID NOT IN ( SELECT DISTINCT Current_Patient_Policy_ID FROM Vouchers)

       AND Patient_Policy_ID NOT IN ( SELECT DISTINCT Original_Patient_Policy_ID FROM Vouchers)

    April 22, 2005 at 10:33 am

    #554384

  • RE: Accessing data across two servers

    check out the BOL about using OPENROWSET.

    April 22, 2005 at 10:11 am

    #554379

  • RE: Formatting Select Columns

    SELECT

       SUBSTRING(SalesName,1,25) As Name

    FROM

       CommERV

    WHERE

       ProcessDate = '1/1/05'

       AND RevDate = '1/1/05'

       AND TIN = '2042416'

    April 22, 2005 at 10:10 am

    #554378

  • RE: Mismatched excel and access column headings

    What you can do is
    (1) get the contents of the excel into a dataset and and parse through the contents of dataset and modify them.
    (2) Then you can...

    April 22, 2005 at 10:03 am

    #554375

  • RE: A Question of Efficiency

    Remi
     
    Why would it be a "lot of overhead" ? It would be like  any other table. Besides the overhead of dynamically building the result set for each query that references...

    April 21, 2005 at 4:52 pm

    #554228

  • RE: A Question of Efficiency

    Prbly some experts over here might have a different opinion. You can have the basic select statement in a view and index the view and call the view from a...

    April 21, 2005 at 12:01 pm

    #554175

Viewing 15 posts - 211 through 225 (of 253 total)