Microsoft SQL Server Forum

Hi, I am working on SQL 2008 database. In Micosoft SQL server Management studio, i am trying to LOAD data in a table, using this query. It show LOAD DATA LOCAL INFILE 'PATH' INTO TABLE test FIELDS terminated by '\r\t';

We currently have a stored procedure with a few parameters and one of them is a list of invoice numbers that is comma separated. The stored procedure creates a temp table, uses a local function to split out the invoice numbers, populate the temp table and uses the data in the temp table to select data from another table. I would like to...

I have an attendance table with attendance per week either "Present" or "Absent" and need to have it changed as follows with reasons attached: If a person does not attend for an entire month he is changed to a "DROPOUT" for the weeks he/she was absent before that month until the time he re-attended. I've tried using SQL that check for...

0 down vote favorite I am having a bit of a problem in SS 2008. I have a front-end form that sends item type and quantity. Then SS would produce IDS that equal the number of the given quantity for the given items. So the input is like: Laptop 1000 UPS 10 The above wouldnt work cos laptops are 1000. But the following works:

How can I Schedule SSIS package execution?? Thanks

Column A has transaction ID that is the same for all Debits and Credits, as identified in another column. I need to see where all Debits equal all Credits for all rows where Column A are the same. So, column A identifies the transaction. Column B has a D or a C. Column C has an amount. I need to find where the debits do not equal the credits for...

I originally had to specify a table in my query, after I did this all the data has populated in the data view except one column. In design view this field: LAST DROP CITY: ORIG_CITY_DESC. does not have a table with that description. I have intermediate level experience and not sure what to do next. This Access query was not made by me but is...

I have a SQL 2005 .bak file that looks to be corrupt. It won't restore using standard gui restore method. The file size looks correct (9.8 GB) but it wont restore. The prior day works but unfortunately this is the one day my server harddrive has completely died. Any way to repair or restore this .BAK and see the data? Inside this database is a...

CREATE PROCEDURE NEW AS BEGIN CREATE TABLE Products (ProductID INT, CategoryID INT, VARCHAR(30), Price SMALLMONEY, INT PRIMARY KEY (ProductID) )

I have a system which stores a date value (Date1) and a time value (From Time) in separate fields and I need to work with the full date/time result (FromDT). How can I add these two values together as this seems to be unsupported by T-SQL? I also have other time fields ( & ) which allow me to determine the end date/time (EndDT) by using ...

Dear all, I lost my database on my pc as I format my hard drive. Now could anyone guide me how I can get a copy of my ms sql server database from my hosting to work with my local pc? I need to have a local copy so that I can develop my site without internet connection. For your information, I'm using Hostforlife.eu hosting service. I have...

I need to calculate which products were purchased by a specific customer in 2014, using Microsoft SQL Server Management Studio 2008. I am trying to combine data from 3 semi-related tables: Customer_List Product_List Product_Sales The desired result is as follows: 5 Columns

I am new to SQL and just inherited a sql database that has 3 encrypted columns. I need to export the data in those columns but it appears that everything is encrypted. I have done a lot of of googling but am unable to find any info on how to encrypt the columns if you dont know how the data was encrypted in the first place of any of the...

I don't know what I'm missing. I have tried to run the following SQL from inside a QueryDef in Access (2003) but it keeps coming back with the error : The multi-part identifier "tW.WE" could not be bound (#4104) That error text actually occurs four times in total in the message. INSERT INTO Avail ( , , ) SELECT . , ....

My understanding from these MSDN pages ({CONCAT (Transact-SQL)}, {+ (String Concatenation) (Transact-SQL)} & {SET CONCAT_NULL_YIELDS_NULL (Transact-SQL)}) is that the + will propagate NULLs, where the server's CONCAT_NULL_YIELDS_NULL property is set to ON as mine is, whereas CONCAT() will convert them implicitly to empty strings. My code, a...

one of my SQL database corrupt. and i dont have any backup ......i got the bigest prob. i tryed to repair will all the 'DBCC' command but none of those works.. i tried 'dbcc checkdb', 'dbcc CHECKALLOC', 'DBCC CHECKTABLE' but none of this find any problem. is there any extra tools or other command to repair MSQL 7.0 Database. please helpppppp...

Hi I am new to SQL coding - need some advice I have data with dates but the dates I have are currently "YYYYMMDD" which is fine and I don't want to change But the data I wish to bring back needs to be data from the last 7 days So

Can you tell me why this CAST(ExtensionData AS nvarchar(10)) AS Expr1 results in an error "Data type mismatch - no conversion possible"? is an ntext column. This error pops up SQL Server Management Studio when I am editing a view; if I ignore it and run the view anyway, it pops up again. It also happens if I use CONVERT instead of...

I have a problem understanding how/why T-SQL refuses the following line within a View : IIF(..='C',IIF(..,'P',IIF(..,'Q','N')),..) AS Error: Error in list of function arguments: '=' not recognized. Unable to parse query text. It seems to be that, unlike when processing the same code in Access, it cannot, or will not, resolve expressions...

I am wanting to replace "in stock", "low stock" and "out of stock" with Values of "20" , "2" and "0" my software only allows me to do one expression at a time. I wanted to know if this is possible and if so how?

Hi, everybody Prompt please, MS SQL 2012 on the virtual computer. Backup of all section with bases every day, at 19.00. That is, for every day I have the file copy .MDF and .LDF. Is there a way to recover the database at a certain time? Not 7 hours, but for example at 12.00. If I just attach the base then at the start I get an error about the...

I have multiple users using an Access front end plugged into a SQL Server back end. I want something that identifies the user's session to SQL server. I've tried @@SPID and found that there can be multiple values when connecting from the same session of Access. Equally, login and user names/IDs are not reliable as it's perfectly possible...

dear all, I have 2000 rows in my table and i want to have subtotal after every 20th row could anyone help me i do not know how to do it. thanks in advance.

Hi, I wonder if someone could advise on the following. I inherited this code, I am not a coder but have had some kind of hack and am looking at code to reduce its vulnerability. At the top of the page I have nPage = CLng(Request.QueryString("Page")) Keyword = Trim(Request.QueryString("Keyword")) in the where clause I have

Hi, I wonder if anyone could help. I have been hacked and one field in my database has had html and links added after the original content. http://www.website.com</title><style>.ajbv{position:absolute;clip:rect(481px,auto,auto,446px);}</style><div class=ajbv><a href=http://ma I need to remove everything after and including the title to...