Microsoft SQL Server Forum

Posting GuideLines Please follow these guidelines when posting questions. Submitting clear and concise questions allow those reading to understand your problem and respond easily. Post your question in a relevant forum Give a clear title to your question Give as much detail as possible Clear explanation (in english if possible you will...

I am working on a Sage 100 (MAS 90) Visual Integrator Job and trying to upload data from SQL. I created the ODBC connection, but I can't pick the database. Does anyone know how to select the SQL database once the ODBC connection is connected to the the SQL Server?

I have database with 263GB where free space is about 45GB. By using below query I executed the shrinking activity. USE GO DBCC SHRINKFILE (N'BriggsAX' , 250876) GO but I got the following error after 2 and half hours. Can you please suggest how I can resolve this issue. Msg 3140, Level 16, State 3, Line 1 Could not adjust the space...

Hello, I must convert a CSV file which is simply hexadecimal words. There is a SSIS function to convert from decimal to hex but none for either hex to decimal or hex to ASCII. Here is what my file looks like: 3032;3631;3031 3032;3631;3032 Here is what it should give: 026101 026102

USE GO /****** Object: StoredProcedure . Script Date: 06/09/2007 20:15:29 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO

In the last few days I have developed a small database within SQL Server, with the aim of improving my knowledge. For now, I need to create a view (for the analytics team), to which the following data should be reported in the view. ➤ Order ID ➤ Date and time of order creation ➤ Customer's first and last name ➤ Delivery date ➤ Item code...

I have the following example, which is reaching the max recursion. Declare @example table (RowID varchar(20), RelID varchar(20)) Insert Into @example Select 'Rec1', 'Rec5' Insert Into @example Select 'Rec1', 'Rec6' Insert Into @example Select 'Rec5', 'Rec1' Insert Into @example Select 'Rec5', 'Rec2' Insert Into @example Select 'Rec6',...

Introduction Starting with SQL Server 2005, you have the ability to create recursive queries using common table expressions (CTE). They are very powerful tools that can be used to query hierarchical data where you don't know beforehand how many times you have to join back to the same table. This is probably the most common use. But they can also...

Ok, I'm looking for expert advice on this one. I have a database which keeps going into read_only mode. Sometimes it goes into read_only / single user mode. Once it was taken offline completely. This seemingly happens randomly. Out of all of the database I have worked with, this has happened on 3 of them - several times randomly to each. All...

I am a beginner and trying to get the following results: All records from page0 where records on page4 do not have a Role of 'DCA Specialist'. Page0 is the one record table and Page4 is the table with the many records. The issue is: I getting records that have 'DCA Specialist' on page4. The Serial Number in Page0 joins to the...

i have the following table: CREATE TABLE dbo.Invoices ( varchar(20), varchar(20), date ) INSERT INTO dbo.Invoices VALUES ( 'INV-001', 'INV-001', N'2015-01-01 00:00:00.000' ), ( 'INV-002', 'INV-001', N'2015-01-01 00:00:00.000' ), ( 'INV-003', 'INV-001', N'2015-01-01 00:00:00.000' ), ( 'INV-004', 'INV-004', N'2015-01-01 00:00:00.000' ),

Hello - and thank you for reading my question! I have experience with IIf and Nested IIf, but I am completely stuck on this one. I have written in 15 versions of syntax and cannot get it to work. Here's what I need - I have an query that I need to analyze four fields of each record. One of these is fields always contains a value, the others...

Hi, I'm using SQL server and I'm trying to create a script to update my table if row exists, else insert into that table. Let's call the table I want to add rows into SALES and my other PROJECT Will always be a one-one relationship. If a new project comes in, I want to create a SQL statement that checks if that project exists, if it does...

Hello, I am a very new beginner. I have the following problem I would like to solve. I have a column named matterno in a table named page0. I have another column named court in a table named page2. I would like to find all matterno that have the court duplicated in page2. I would like to include both matterno and court in the results. ...

I'm having trouble using some of the newer/odder INSERT/SELECT INTO syntax's They run just fine from a .SQL dialog from VS2015, but not within a SQL unit-test. In all cases I am populating a temp table and using MSSQL 2015. This standard syntax works just fine in both a SQL unit-test and as a SQL script in DevStudio; INSERT INTO #Expect...

I was reading an article here about database corruption . The author says to run CHECKDB command when some suspicious activity is noticed in the database. I do not see the logic in waiting for that activity and maybe going past it and using or creating corrupted data when it is not noticed. Therefore, how do I automatically run CHECKDB...

I have 4 columns a ,b ,c, d sample data a | b | c | d | 1 | 1 | 101 | 0 2 | 1 | 101 | 0 3 | 1 | 101 | 1 4 | 1 | 102 | 0

Hello Everyone, First I would like to thank you to anyone that give an answer to my question. I have a table like this one below (KeyID is auto-increment)... KeyID UserID Amount 1 12 1.00 2 09 1.00 3 12 5.00

Installing SQL 2019 on a new server. I would like to use the old license which is 2008. How can I find the license> THanks!

What would the query look like if I want to update data to another server, it has been linked already. Using a sub query once it runs I want that data to be moving over to the other server. Also this will involve multiple columns.

Hello, Following on from above is it possible to do similar as above exclude bank holidays but due to permissions on the server I am unable to create a table currently.

Trying to update data from one server to the server. There are 3 columns: Year, Site and Code that need to be updated from my current server to Server2, however I keep on getting the error of "The multi-part identifier could not be bound." Below is my query: UPDATE ... SET ....= Poll., ....= Poll., ....= Poll.

Created a query in server A to populate data for columns C,D,E. Now I want to move information for those columns C,D,E in another database in server B. I have already linked the servers.

The data would be updated daily in the other server. I have stored my query in the temp table and it is pulling from there, this is the table name: #TEMP_TBALE_TEST. Below is my query UPDATE .. (This is the database, table name in another server, which I want the data to be updating in daily) SET ... = #TEMP_TBALE_TEST. FROM...

Hi, I have a table with below 6 columns, I need to sum the amount together if Name + Campany + age + Gender are the same, and the result needs to keep at TotalAmount Column. Name Company Age Gender Amount TotalAmount Nick A 40 M 800 Nick A 40 M 1200 Nick B 40 M 400 Nick B ...

Greetings experts. I'm trying to figure something out and I'm having no luck. This query works fine as a direct query but my requirement is to make it into a procedure. The error from the proc is "Invalid object name 'Query'". Here is the query. SELECT TOP 5 Name, Sev, COUNT(SimID) AS Count FROM ( SELECT C.Name, B.SimID, (CASE WHEN...