Microsoft SQL Server Forum

Gang, I am currently outputting data into text files using BCP and "exec xp_cmdshell". The other day a peer of mine saw my code and said that this was 'ancient technology'. Funny thing is, he didn't bother to tell me what I should be using instead. I know I could probably be using SSIS but for this specific purpose I wanted to keep it within my...

I want to be able to set a invoice issue date. and have it automatically update by 30days in the invoice due date. In a Microsoft Access Database. Thanks for your help. Peter

Hey People, I'm Getting "arithmetic overflow error converting expression to data type int" While Updating And Deleting Please Look @ the Following Attachment Below And This Error Only Occurs For One Record.

i want to do something like this; for-example; Set vote = true for all rows in tbl_emp where pk_tbl is in the comma separated value list. update tbl_emp set vote=true where pk_tbl in @empl_vote_true Where, @empl_vote_true = ’12,23,345,’ (IDs of the employees),

hi i want to get date difference between two columns. month and DOJ in days. month is integer datatype and doj is in time stamp. the colums data was like this. i mentioned '|' in btw of 2 columns for your clarification. doj | month_sid 5/30/2008 12:00:00 AM | 201103 5/19/2008 12:00:00 AM | 201111 5/19/2008 12:00:00...

I have a table in SQL with the following columns and data: First_name is Joe Last_Name is Smith Zipcode is 12345 Join_date is 05012011 xmldata is <data>Network Admin</data> <definition_field_id>beaa46b0-d1bb-408a-a5cc-56764f8562b6</definition_field_id> <validation_status>Valid</validation_status>

Select DeptName,IPDID,Sex,FactorName,DeName,ProvinceName, Jobs,MaritalStatus,LifeInsuranceType from ViewIPDReport Where DateAdmitted BETWEEN '01/06/2012' AND '30/06/2012' But error: Msg 241, Level 16, State 1, Line 1 Conversion failed when converting date and/or time from character string. Please Help me... Thank you in...

I have a Invoice Number that can appear in either two tables (history = table A and current= table B) which have all the same fields, but not both tables at one time. I want to check If the invoice is in table A and if so then grab other fields, if not check table B. How would I write a Case statement of If Statement for this?

i have a table in format item_id packet_no 1 4 1 5 2 6 3 7 3 8 3 9 4 10 4 11

Sql server service stops immediately after starting.What are the possible reasons behind it? Please explain. Thanks in advance.

If i create an index on Varchar column, It improves the query performance? Yes or No.Explain Thanks in advance

Hello masters! I'm trying to figure out whether it's possible to obtain SSRS reports using information from Access. I mean, I've read that I can link SQL Server 2008 with MS Access (link server), but I still haven't found if I can use this link to get Access information and generate reports with SSRS. I would appreciate if anybody could help me...

I have a table with one column that contains blank(''), null, numeric & varchar data. So when I wanted to find values which are numeric & between a range I wrote something like select Value from Table1 where isnumeric(Value)=1 and Convert(numeric(10,2), Value) between 110.00 and 115.00 which works fine. But when I change the order of the...

It error like this: The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details. Help me please

I have a VB.Net application that uses ODBC connection to interact with database. I have configured DSN from contol panel and tested it successfully. But when i am trying to connect to that DSN from my VB.Net application then it shows error that SQL server does not exist of access denied. One another thing, when i run an old .exe file of same...

Issues with a SQL trigger, it takes 10 seconds to run and I cannot see why...please can you help: USE GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER . ON .

Hi, i had a table like below which contains some rows and columns. rowid a b c 1 2 3 now i want the output like

Hello, I downloaded SSIS 2012 (beta) and try to learn it. Lession 1 can be done without problem. Now I proceed to add ForEachLoop at step 3 in lesson 2. In step 3, it needs to modify the Flat File Connection Manager, following Microsoft course guide I proceed to 3. In the Properties Expressions Editor dialog box, in the Property column,...

Hi All, We are implementing a solution using java where we will pass xml data to SQL stored procedure, then stored procedure will parse that data. The data can have special characters and SQL server specific keywords like DEFAULT etc. How can we make sure that the special characters (both xml and SQL Server specific) and SQL server specific...

I want to loop through a table and count the ids where they are equal to a tables ids, however if the Id count is equal to 1, I would like to put that id into a table. I.e. I am trying to get the ids from a table where the id inly exists in one row. If the id exists in two or more rows, then it is excluded from my results. Can you please share...

hai all can anyone explain me how to pass the tablename as parameter in storeprocedure..thanx in advance........

I was running the following code in sql server 2000 dev. edition 1. BEGIN 2. NULL; 3. END; when i got the error: incorrect syntax near the keyword ‘NULL’. I also tried: 1. SET SERVEROUTPUT ON SIZE 1000000 2. BEGIN

i have one query Where When i m filtering data on the basis of 2 dates it will take 2 min to execute but when i remove that condition it takes 1 sec, only

I have problem for executing hibernate query for selecting japanese data which is in NVARCHAR datatype column. If I Prefix literal unicode strings with 'N' in HQL query, it will give exception as --> org.hibernate.hql.ast.QuerySyntaxException: unexpected token: '日本語' Any help will be Appreciates. Thanks, Nilesh