Working is SQL server 2005 using SSMS 16
I have a stored procedure in a database exec get_info 'ID175143'
Msg 2812, Level 16, State 62, Line 22
Could not find stored procedure 'get_info'.
I found a sample code online to get the last part of a string.
This is SQL 2016. I need to get the digits (4576893 for example)
This works. You see there is no forward slash after 4576893
If I have a column like this:
[ "abcd", "xyz", "123" ]
How can I parse it? I want to parse it and insert them in a table (3 rows in this case)
This is sql 2014
I have a function that accepts some parameters and returns a results string.
Now I need some help figuring out why the section below only works when the results …
I'm parsing a JSON file and the datetime field looks like below and I get an error.
What data type I need to declare for it to get the datetime? This SQL 2014
This project still uses Visual Studio 2005 SQL Server Business Intelligence Development Studio and is doing some strange things.
I added a single column to an SSRS Report and get it working fine.
"Are triggers slow?" is a general question that I know depends on what the trigger is doing.
This is sq 2014.
We're importing more than 50,000 rows of data. Some calculation needs to be done on …
I am getting the error which is described in this article:
However when I apply the 'fix' …
when tempdb log keep growing an un controllabe, what T-SQL command we should use to check what the log is waiting, what process is running against/locking the tempdb log before it can be …
I am wanting to copy a table, its structure, indexes primary keys constraints etc. how can this be done via t-script or Stored procedure.
I keep getting this error.
Msg 117, Level 15, State …
We have legacy shared application/DB server that requires us to downgrade the installed MS SQL Version / Edition
The server hosts an older application and has a single database only within …
How could I go back a fiscal year for a given date?
My organization use the format of the Fiscal year as follows:
'FY2015', 'FY2016', 'FY2017'
I need to get these values automatically using …
I want to result like:
I am able to get the Present/Absent status of a user for a single date. But my question here is that I want to get all the users that are present/absent …
How to I change this to get the right result in LAG_ROWID see what I got and what i expected
Note the last in the series always has to be NULL too !
SELECT ROWID, AcctID
, ROW_NUMBER() OVER ( …
I have a table "RENEWALS" with 55 records which has a column called ROWID
I want to update this column with a sequential number 1 to 55
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…
Output I need below
Keycol data LineNo
I have this query that is supposed to look for instances occuring within the same timespan as the given dates. What I want is to see is if a person with a particular personID is booked …
What is the error in this code.?
DECLARE @OrderId AS INT = 10028
SELECT * FROM Orders
WHERE OrderId = @OrderId
Appreciate your help.
I have two tables (tablea and tableb). I would like to set the value of a column in tablea (call it tablea.column1) to zero, if I find a matching row in table b. The matching is done on 3 fields. The …
I have a SQL database that has a table for invoice header information and another for invoice detail information linked on invoice number. There is a 1:many relationship between header and detail. I…
Whats wrong in this query - Select * from tableA,tableA
I choose to run update statistics via maintenance plan, however when the update stats is complete I realized only some of the tables get updated whereas most of the table are not being update …
I have this currently but its producing duplicate rows.
I added a group by before the where and added the fields from prev and data table but it wouldnt run
Why i am getting a star, SSMS does not show me any error. Division Error
SELECT CONVERT(VARCHAR(2), 7140 / 12)