Search:

Type: Posts; User: szlamany

Page 1 of 13 1 2 3 4

Search: Search took 2.80 seconds.

  1. Re: how to write in excel file of sql query result

    This should work


    insert into #table_Northwind (column_name)
    (SELECT TABLE_NAME
    FROM INFORMATION_SCHEMA.TABLES
    where TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='Northwind' )
    declare...
  2. Re: how to write in excel file of sql query result

    Where did you get this? And what is it supposed to do?


    Set @tbl_name = (SELECT (select column_name from #table_Northwind where RowID=@i) 'TableName' , o.name, [Scehma]=schema_name(o.schema_id),...
  3. Re: how to write in excel file of sql query result

    I've never even seen this type of OPENROWSET use to create XLS files. That was a link given to you by JDC2000 in the second post here in this thread.



    while @i <= @max begin

    Set...
  4. Re: how to write in excel file of sql query result

    Ok - so you limit yourself when you say you want an older version .XLS format file.

    And I cannot imagine how a STORED PROCEDURE would interact with EXCEL.

    Now you can flip the issue and...
  5. Re: how to write in excel file of sql query result

    How to you intend on creating the .XLSX file?

    I am assuming you are creating this type of EXCEL file and not the older .XLS type.

    I am also assuming you are not creating a .TDF file - which...
  6. Thread: Post Race!

    by szlamany
    Replies
    65,984
    Views
    10,456,914

    Re: Post Race!

    This might not be safe for work...here goes anyway! Google search for Chata Maxov. Go to Maps... satellite view...scroll to the right a bit and check out that odd roof top! Someone had a lot of...
  7. Re: Server based listener to send file to web client

    You can write two "test" apps in the same project. One is the listener, waiting to get a request for a file, the other is the requester, ready to request a file.

    This is my code to setup a...
  8. Re: Server based listener to send file to web client

    I've used http listener logic just like that, to have 4 remote services communicating and sending files over the wire.

    I'm assuming that the backend code running on the GoDaddy web server will...
  9. Thread: dotnet tools

    by szlamany
    Replies
    2
    Views
    303

    Re: dotnet tools

    Interesting - thanks for the links.

    Is this similar to Android namespaces where you can call on "external" code? It's been a while since I played with Android - I might be using wrong terminology...
  10. Re: Find the DataBinding Error... Or Where is Waldo?

    Just a suggestion - and sometimes the path I follow when building up new efforts in code.

    Start with a few fields - even a single field. I always like to see that the plumbing works, especially...
  11. Thread: SQL Express

    by szlamany
    Replies
    26
    Views
    709

    Re: SQL Express

    If you had access via SSMS, you should be able to get access via the exact same connection method in your VB code.

    To see how SSMS is connecting, right click the DATABASE from the EXPLORER pane...
  12. Replies
    9
    Views
    291

    Re: getting this long sql qerry to vb

    Dim strQuery as String

    strQuery = "SELECT" _
    & "p.ID AS 'Order ID'," _
    & "p.post_date AS 'Purchase Date',
    & "MAX( CASE WHEN pm.meta_key = '_billing_email' AND p.ID...
  13. Replies
    9
    Views
    291

    Re: getting this long sql qerry to vb

    Something like this:


    rs.Open "SELECT dbo.GetConf('" & ConfItem _
    & "') as ConfData", gCn
    GetConf = rs!ConfData & ""


    But better built as a string variable - easier to debug.
  14. Replies
    9
    Views
    291

    Re: getting this long sql qerry to vb

    Welcome to the forum!

    Are you using MS SQL Server by any chance?

    If you want that big query in VB code you are going to have to build a string with line continuation.
  15. Replies
    16
    Views
    372

    Re: Windows Nearby sharing

    I mentioned this new feature to an IT professional just 30 minutes ago. They already assessed it as being of no use in an enterprise network environment and set a GPO to disable it on the network.
    ...
  16. Replies
    16
    Views
    372

    Re: Windows Nearby sharing

    Taking work documents to your home PC is a violation of most corporate security standards. It should be shut down.

    File sharing should be done through OneDrive links or ShareFile links, or...
  17. Re: How do you all encrypt connection strings in WEB.CONFIG?

    Found this link - and it worked perfectly

    https://techcommunity.microsoft.com/t5/iis-support-blog/connection-string-encryption-and-decryption/ba-p/830094
  18. [RESOLVED] How do you all encrypt connection strings in WEB.CONFIG?

    How do you all encrypt connection strings in WEB.CONFIG?

    TIA.
  19. Replies
    11
    Views
    517

    Re: eleminate surgable dates

    Sometimes it can be faster to bring key selection fields into a temp table and clean them up. Include whatever primary-key fields so you can JOIN up your final SELECT.

    Can you step back and...
  20. Replies
    11
    Views
    517

    Re: eleminate surgable dates

    Why is this item concerning you? If you take it out, or just hard wire one of the results in that field, does it change the speed of execution?
  21. Replies
    12
    Views
    952

    Re: log4j - High vulnerability malware

    This is twitter actually funny!
  22. Re: SQL Server Windows Authentication - Running application as another domain user

    I put this in a .BAT file and it works...

    Runas /netonly /user:xyz\szlamany "C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe -S server.name.or.ip.address -d...
  23. Replies
    1
    Views
    335

    Re: SQL record locking / sharing.

    SQL has "transactions" that allow a single user to interact with a set of tables in the database while naturally locking out other users.

    BEGIN TRAN is the SQL statement that "starts" the...
  24. Thread: Post Race!

    by szlamany
    Replies
    65,984
    Views
    10,456,914

    Re: Post Race!

    I've always been told I was in charge of the evens. It's kind of my nom de guerre.
  25. Thread: Post Race!

    by szlamany
    Replies
    65,984
    Views
    10,456,914

    Re: Post Race!

    I'm guessing that is near Vegas? Strange name otherwise...
  26. Thread: Post Race!

    by szlamany
    Replies
    65,984
    Views
    10,456,914

    Re: Post Race!

    I'm just a greeter at the front door.

    "Welcome to Sam's"
  27. Thread: Post Race!

    by szlamany
    Replies
    65,984
    Views
    10,456,914

    Re: Post Race!

    I live in a neighborhood that was named after the first president of the US (or at least the Continental Congress) - Samuel Huntington.
  28. Replies
    15
    Views
    775

    Re: [RESOLVED] Help with a query

    No need for SELECT DISTINCT with the GROUP BY. You want to make sure the GROUP BY is working properly, and DISTINCT would mask that, imo.

    I am very, very against DISTINCT, fwiw...
  29. Replies
    15
    Views
    775

    Re: Help with a query

    It was MMock that floated the business requirement of knowing the count of trips and those in CP status.

    With that said, building that DB object once and testing it robustly is a standard...
  30. Replies
    15
    Views
    775

    Re: Help with a query

    @zvoni - count the money, lol!
  31. Replies
    15
    Views
    775

    Re: Help with a query

    Seems it would be something like this:


    Select *
    From Jobs
    Where Jobs.Status='CP'
    and Exists(Select * From Trips Where Trips.JobControl=Jobs.Control
    and...
  32. Thread: Post Race!

    by szlamany
    Replies
    65,984
    Views
    10,456,914

    Re: Post Race!

    Moodus here in CT is named after a Sachem tribe - and is famous for the mysterious Moodus Noises!
  33. Thread: SSL Issue

    by szlamany
    Replies
    3
    Views
    796

    Re: SSL Issue

    Is this IIS? Are you only able to get to a dash board screen to manage the web service?
  34. Thread: Post Race!

    by szlamany
    Replies
    65,984
    Views
    10,456,914

    Re: Post Race!

    NSFW stuff, lol!
  35. Replies
    63
    Views
    2,679

    Re: Ignoring moderators

    Now that is classic panties-in-a-bunch! We get it - they don't like the Rust core group, lol!
  36. Re: Getting the ball rolling. Which VB6 projects are you working on?

    Murder? Nah - vb6 died of natural causes from what I see!
  37. Replies
    63
    Views
    2,679

    Re: Ignoring moderators

    Lol!
  38. Replies
    63
    Views
    2,679

    Re: Ignoring moderators

    Moderator, Smoderator. Maybe just glorified hallway monitors, making sure you don't cut in line for the water fountain.

    We've had Three Eyed Frog moderators before! Ones with way too many...
  39. Re: Getting the ball rolling. Which VB6 projects are you working on?

    Recent posts in a couple of threads here are reminding me of One Flew Over the Cuckoo's Nest.

    Trying to figure out which one of you all is Nurse Ratched and who is Jack Nicholson...
  40. Replies
    15
    Views
    1,071

    Re: Many old unresolved threads

    I've certainly seen you do your part for the "discussion" here, lol!

    And yes - agreed and totally my point.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width