Forum Replies Created

Viewing 15 posts - 1 through 15 (of 29 total)

  • RE: SSIS

    What I did, from the SQL ToolBox book, for template is, create an actual package with all standard connection and component generic to my development and save it to sql...

  • RE: Row_number() in SQL 2000 ...

    Okay. I'll try that and get back to you guys. Thanks for all of you participated.

  • RE: Row_number() in SQL 2000 ...

    Okay ... so this seems to be more intesting then what i originally thought it would be ... huh ?

    Great approch you all. But the problem is still unsolved....

  • RE: Row_number() in SQL 2000 ...

    Oops again!!

    Hey Chris,

    You looked over one little itsy bitsy detail ... i need to do this in SQL 2000.

    Thanks you.

  • RE: Row_number() in SQL 2000 ...

    Yeah you are right, i need excatly this.

    I kinda need a sequence within each set. I wish if I could see some sort of code for that ?

  • RE: Parsing A Merged Text File Into Respective table text files

    Thanks for the help. To give you a clearer picture ... here is a sample file data. In the below the 1st line is the header for the consolidated file....

  • RE: Blackle

    Black background is easy on eyes, for me. By the way its quite old school ... remember blackboards in school?

    Also the question is...

  • RE: Time Off

    I might not belong to that part of the world but long weekends ... aah ... what a luxuary .

    If I get one...

  • RE: How to import MS Access database into SQL Server 2005

    You can also use SQL data import export feature. Just create a new database (in which you want to import your access file) with options you like; default would be...

  • RE: How to break up a varchar variable into bite sized chunks

    You have got the logic right. Just sprinkle some more checks for sentences detection and you got what a typical VB6 programmer ( like me ) would do

  • RE: What am I missing?

    Just posted quite similar script ... just above yours :p.

    Good point regarding the 'registered size in memory' concept. Clears things more. Thanks.

  • RE: What am I missing?

    Another point that i think found me is, I am not sure if that is relevant or not. But when running the script below:

    declare @a float

    declare @b-2 float

    set @a= 10

    set...

  • RE: What am I missing?

    Just a brain fart ... for getting more then 2 decimal places you cab use this ...

    declare @p int

    declare @n int

    set @p = 10

    set @n = 3

    select CAST(CAST(@n AS...

  • RE: Call Procedure in Visual Basic

    Thanks. Happy SQL-ing =)

  • RE: The 64-bit Question

    Happy Anniversary.

    Keep doing what you do, doing a greate job for the online SQL Server community.

    FP

Viewing 15 posts - 1 through 15 (of 29 total)