by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Karl Burtram
    @kburtram
    @jetstreamin if you have the servers registered in a Registered Servers group you should be able to execute a query across the group to accomplish a federated query.
    Mike Mahon
    @jetstreamin
    yeah, I got it figured out... I had jack with network settings, my client decided to use non-standard ports on internal development servers so ...
    Hédel Nuñez Bolívar
    @hedelnb_twitter
    Ghost
    @ghost~5d8c5a1bd73408ce4fcc1484
    Hi, sorry to bother all you experts with such a simple problem but my knowledge of sequel is VERY limited. The problem I'm having is I have an excel sheet that I'm supposed to take data from and put it into the SQL DataBase. It's a local DataBase so if I do screw up then it won't affect the company and I can use it to just instead learn but I've been fighting with this problem since yesterday and I'm tired of it now. The guy I got this task from, sino, wants the code in the excel sheet so I can give him the file and he can manage the live DataBase so this is what I've written so far and changed a hundred times by now hahaha. ="INSERT INTO [dbo].[Audit] ([Submission_date], [Audit_date], [BuildingID] ,[Building],[Room_barcode],[Room_number],[AssetUserID],[Responsible_person],[Asset_barcode],[AssetDescription],[Condition]) VALUES ('"&TEXT(B2)&"','"&C2&"', '"&D2&"', '"&E2&"', '"&F2&"', '"&G2&"', '"&I2&"', '"&J2&"', '"&K2&"', '"&R2&"', '"&M2&"')". I keep on getting an error about the conversion from string value into datetime failing for the column Submission_Date but even when it is in datetime format I'm getting the same error. Any ideas? sino wants it in this format somewhat and insists that his =TEXT(B2, "YYYY-MM-DD") is right.
    Ghost
    @ghost~5d8c5a1bd73408ce4fcc1484
    Nevermind, I got it to work.
    Hédel Nuñez Bolívar
    @hedelnb_twitter
    @0ddC0d3 glad to read it :) sorry for be late
    fred
    @fredpoon
    Launching server using command c:\Users\<user>.vscode\extensions\ms-mssql.mssql-1.6.0\sqltoolsservice\1.6.0\Windows\MicrosoftSqlToolsServiceLayer.exe failed.
    anyone run into this?
    Hédel Nuñez Bolívar
    @hedelnb_twitter
    @fredpoon what said event viewer
    Automatic Subscriber
    @autoadsubscrib_twitter
    图片.png
    Hi all
    I updated my VSCode to 1.40.1, but I find the top two icons for exporting are missing
    The missing two are 'save as CSV' and 'save as JSON'
    Automatic Subscriber
    @autoadsubscrib_twitter
    By the way, have the developer group scheduled offering support for exporting DBF ? I guess it would be of great help, since there are few software available offering this function now.
    Oasis
    @oasisfleeting
    I have a scheduled database redesign task coming up next month.. Hoping to split the database up over 4 drives of 500GB a piece and take advantage of some of the IO benefits from asynchronous reads.
    Not sure how virtualization will impact that IO
    Kylee Webb
    @kyleewebb7
    I am not seeing the database icon on the bottom left and therefore cannot open mssql... can anyone help me?
    Kylee Webb
    @kyleewebb7
    Does anyone know what we are supposed to put here?
    Screen Shot 2019-12-11 at 4.14.30 PM.png
    above where it says 'Server name or ADO.NET'?
    Joshua Dapitan
    @joshuadapitan
    the name of your SQL Server instance
    无限风灵
    @WuLex
    (︶︹︺)哼
    use vs
    ste
    step and step
    Tim Bush
    @t_busht_twitter
    Screenshot 2020-01-01 at 10.53.04 PM.png
    Hi all, has anyone successfully got the mssql extension for VS code running on ARM hardware ? I've got this far with headmelted 's build, running as a Linux App in Chrome OS, on an Acer Chromebook Tablet :P
    Tim Bush
    @t_busht_twitter
    Screenshot 2020-01-01 at 11.00.15 PM.png
    VipinPokhriyal
    @VipinPokhriyal
    Hi All,
    Can anyone suggest to me how to setup the MSSQL cluster using docker in ubuntu?
    eAlie
    @ebadali
    Hi Folks,
    I have this weird bug showing up out of nowhere. When I do Bulk Insert with formatted file, it skips the first column (not row). I have tried almost everything( using bcp to generate file, using the short header file, etc). It just does not seems to make any sense. Do you happened to encounter something like this ?
    eAlie
    @ebadali
    Just found the fix : This is super weird, I had to move the identity column position to the last of my destination column
    Bård Eik
    @bardeik
    Hi, hope someone can help me with an issue. When I have an open connection and use Ctrl + Shift + E, I run the query just fine, but If I select the text and then run the query, it pops up "Server not selected". Any idea on where I go wrong? The same message if I select a text, right-click and selects "Run selected text as query"
    Bård Eik
    @bardeik
    @bardeik Found a workaround. Removed Crtl + Shift + E keybinding on "Run selected text as SQL query", and added this shortcut (Ctrl + Shift + E) to "MS SQL: Execute Query" -> Does not check for selected text, but it only executes selected text, so works for me :-)
    VipinPokhriyal
    @VipinPokhriyal
    Hi All,
    is there any way to push data into using a trigger approach in mssql.
    Rakib Ahmed
    @Rakibxl

    I have a one table Called MeetingInfo. In that table there is a info regarding Meeting Start Date and End Date And Metting Room.

    I want to make a query by which i want to see all the Meeting start Date and EndDate but From today to 365Days Ago. Below Way i am trying

    DECLARE @TodayDATE = GETUTCDATE()

    Select * from MeetingInfo

    WHERE StartDate between DATEADD(DAY,-365,GETDATE()) and@Today

    AND tbia.EndDate between DATEADD(DAY,-365,GETDATE()) and @Today

    What do u think this is the correct way to see the results

    Kay
    @kaysauter
    @Rakibxl first off, if you use GETUTCDate(), then this ma return some surprising results depending on where you live / where this server stands and the user is
    That is because the timezone offset is not included for this. if you want to respect this (and have reason to use this), then you need to keep in mind that you will have timezones to display for each user depending on her or his location
    However, interestingly, you use GetDate() in the Filtering section, so this will probably have efffects on this.
    but apart from that, it seems good to me, but I haven't tested this.
    alealpha2000
    @alealpha2000
    i have a sql question.i have a query like this. how can i change it so instead of counting one column in the group, it counts the combinations of two columns inside a group
    select column1,count(distinct column2)
    from table
    group by column1
    00sivan
    @00sivan

    @alealpha2000 You could use CONCAT(column1, column2) -
    Example1:

    select COUNT(CONCAT(column1, column2)) from table1 group by CONCAT(column1, column2)

    Depending on what you're counting, as you seem to need distinct values, you may need to use window functions to deduplicate first. Google deduplication and "over(partition by" for help with that. If you go that route, you may need to wrap this in a CTE;
    Example2:

    ;with A as (select concat(column1, column2) as 'NewName' from table1) select count(NewName) from A

    amishraa
    @amishraa
    can anyone please help me with sql server connection strings using windows authentication?
    sakenzhuma
    @sakenzhuma
    Good Day. Have a question, could you please give me your insight. For select on website, is it good idea to have two columns to save select I'd and its value? Thx.
    Marcelo
    @marcelosf
    Hello everyone.
    I need some help with mssql connection. When I try to connect to mssql server I get this error:
    ´´´
    Message Iteration=2|SQLState=IM006|Native Error=|Message=[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed[Message Iteration=3|SQLState=08001|Native Error=|Message=[Microsoft][SQL Server Native Client 10.0]Client unable to establish connection]'.
    I'm trying to connect to a mssql server 2019]
    Nick
    @nj-db
    Hi, can anyone please point me in the direction of some information to do with using a SQL FileTable in a document versioning system? Thanks
    matrixbot
    @matrixbot

    gympuma > <@gitter_nj-db:matrix.org> Hi, can anyone please point in the direction of some information to do with using a SQL FileTable in a document versioning system? Thanks

    Could you explain a little more? You want to log versioning in SQL? Generate documents from t-sql into a file system?

    matrixbot
    @matrixbot

    gympuma > <@gitter_marcelosf:matrix.org> Message Iteration=2|SQLState=IM006|Native Error=|Message=[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed[Message Iteration=3|SQLState=08001|Native Error=|Message=[Microsoft][SQL Server Native Client 10.0]Client unable to establish connection]'.

    What connection string are you using? (blank out sensitive info before sendind)