I have the following query:
When I run it though I getting the following errors:
Database name 'TempDB' ignored, referencing object in tempdb.
What is causing this error…
there is a loanID 'AAA' In table #txloans, but it is not in table tblapplicants. How can I query a results, something like
I have a 742,871 records report in sql server management studio. The field which has comma in the text will be broken down to a new column when exporting to CVS. How can prevent …
I need to read a text file and insert specific values into a table in sql server, I have the starting position and length of fields I need to read from the text file, but I needs some hints on how to …
i checked syslogins & sysusers and the domain login is valid in the database
it has datareader permission.
but the users get this error:
the database is not accessible.
Other users with …
I have two tables one with fields I need such as ID, clientID, table andCustomerID the second table has the ID of the record in table and a total column. I am trying to get a subtotal …
I am having these erros:
Msg 207, Level 16, State 1, Procedure GeraArqEmbarqueHonda, Line 20
Invalid column name 'id'.
Msg 207, Level 16, State 1, Procedure GeraArqEmbarqueHonda, …
When I call my procedure I got an error:
Msg 208, Level 16, State 0, Procedure GeraArqEmbarqueHonda, Line 12
Invalid object name '#temp'.
Why? And how to solve this?
Is there any simple way to detect and resolve SQL server database deadlock ?
My custom application hangs and the developer suspect that there is deadlock in the DB which I must fix for the…
I want to get four query results, not two:
select count(*) as SecondYearInterestIsNo from APSecondYear where SecondYearInterest='No'
select count(*) as SecondYearInterestIsNO from APSecondYear…
Hello Experts Exchange
I'm new to SSAS cube development.
I have data for cost centres that are going into my cube, please see file attached.
I want to create a SSAS Hierarchy with the data.
I have some data that I was to parse or separate out, that is initially in 1 row and want to separate into
different rows. As seen in the data samples below. I was looking at examples but they…
I want to count 'case when'
the query will be similar like (CODE)
Please see the data example in the attachment.,The query should catch the yellow highlighted part. The result …
there is a need to make a varchar (100) little higher.
if this is done on a live system with many update/insert/del to this table, do you see any issues when making it to varchar(150), without …
is there anyway to show the number of an order in a list of orders. 3 out 17 for example
so the table has order number and orderdate, i want to run the query with a where statement of an …
I am working In a company where there are many queries made with this kind of date filter
SELECT * FROM TABLE
WHERE CONVERT(VARCHAR(10), DATE_ORDER, 112) = CONVERT(VARCHAR(10), …
how to upgrade SSIS from SQL 2008 to SQL 2014/2016.
From my experience for all SQL server upgrade project I done myself which has no problem, SSIS package always no problem, but when SQL server …
I have 3 queries like follows: I am not sure how to make the union due to the cte...I was thinking the cte might have to be a temp table and the the unions some how combined that way..Please help …
I am running to into an issue where when I try to export a table to a text file I get an extra line between each record
123 test one
124 Test two
BCP Version: …
We have several machines on the same network, however services are firewalled (ports 1433, 1434, etc are scoped or firewalled off from the other servers)
However, when using SQL Server Native …
I am not sure how to do this. I need to loop through these two parameters and then insert into temp table. I have most of it written, but how would I go about looping and doing the insert?…
I have this Windows 2008 R2 Standard server with 12G RAM memory installed, 64 bit version.
The server end up slow and using all the available memory, then i have to restart the MS …
Hello we have one computer that we updated to Active Directory and SQL server was running jobs when we authenticated with windows authentication mode and all was good but after install Active …
Output I need below
Keycol data LineNo
This query failed to run in sql 2014 but run okay in sql2008 R2, any thoughts ?
HOST_NAME AS [System Name],