When I execute the following stored procedure in SQL Server 2008, I get the error
Msg 102, Level 15, State 1, Procedure proc_CSL_AutoDetStop, Line 7
Incorrect syntax near '='.
Do you know how …
I am trying to update the table. where I have following columns:
folioNo is the order
pgPos is either right or left (if folioNo is odd then put L (left) if even put R(right…
I have a stored procedure in sql server 2012 which I pass in a comma separated value, loop it and update a table...all good.
but now I have 2 lists to handle now which they need to be pair…
When doing a query on a table with multiple indexes how can i know which one SQL is using?
How would i use OPENDATASOURCE to insert the records from a table in one database table to an identically named table in another Sql server instance on another server?
I have a database in SQL Server 2008 that is reporting it is 1.5GB when the actual size is a fraction of that.
EXEC sp_spaceused reports that the database is 1533.07MB
EXEC sp_msforeachtable '…
i am trying to insert
INSERT INTO [CORRCE] ( [Year_Ref] , [Ref] ,[Date] ,[SentTo] )
('22' , '556' , '21 September 2016' , ' hotel 's b'a')
Any assistance would be greatly appreciated. BIG THANKS!!!
Delete items that are no longer available in the database:
1) I would like a query to compare the 'Item Number' column fr…
I need to get the next and a previous instructor for the session, I got the code working with one little thing The instructor have to distinct.
I am having an issue where SQL Server does not see a Foxpro DBF file when I attempt to import using SSIS. I see all other files except WOYTRN01.dbf. I am able to update with the following statements b…
I have table 'users' and field 'dob'
dob is an navarchar field and has the following type of values: Aug 1 1968 12:00AM
I need to run a query to format such values as if they are dates, so it …
I want to create a stored procedure to then schedule with SQL agent. Never created one before. Help plugging in the select statements below into the stored procedure template will be greatly appreciat…
Currently still using SQL Server 2005.
I have a table that has one row for each clock in or clock out like the attached file (hoursworked.xlsx) Notice the first employee worked two shifts per day.
I'm looking for input on ideas to keep in mind when planning and creating a MEDICAID data warehouse. This data will be used to help identify WASTE, FRAUD AND ABUSE.
Has anyone worked on…
I like to test the connection to SQL Server. My Web Site is running under AD account Domain\userA.
my connection string is connectionString="Data Source=server\instance;Initial Catalog=Datab…
I am trying to convert a datatype of an column in sql table to money .But it fails due to some data which cannot be converted to money.How can I check in the table which data is causing the…
I want to run the following statements from a command line and schedule it. How would I accomplish this?
Getting error message when running a job when scheduling a job using a linked Server. It fails when it runs the following statements below. Screenshots are attached. Both scripts run fine in a query …
How do I change all highlighted to D: drive in SQL with one query.
Hello experts, I have a 2005 MSSQL server with a databse with a lot of free space in it.
Before any warnings about how bad it is to shrink databases, I know, and the client dimissed all my warnings.…
I would like to cast Breite1, Laenge, Staerke AS double that this query will work right.
In my sql they have the typ: varchar.
Sql_Search_String.Format("SELECT * FROM Angebot_Anfrage WHERE…
Hello EE, I have a column field in a table called "Instruction Text"
inside, users are puting text and a date such as :
DATE JOB FOR OCTOBER 20 BlaBlaBla
Date job for November 18 BlaBlaBla
In my project, I have a finger print scanner. When the students scan their finger, I insert the record in SQL Server. It is inserting duplicate records exactly at same time.
I am currently using this statement to query a linked Server: (CODE) and it works fine.
I want to add a WHERE clause to filter by date using the RECDATE field. I try (CODE)
but it is not working…