Microsoft SQL Server Forum

Is it possible to prefix A_I field with a number like 301? My initial approach was to check if data exists in table. If no data exists, i would turn on auto increment insertion, insert 3011 then turn off insertion. Would this approach make the operation slow since everytime a row is added, it will do the check, on n off then insert the record? ...

I need to pass the @startDate and @endDate as variables to @range in the code given below. But when I execute the below code, I'm getting the Error as follows. What is going wrong in my code, and how can I correct it? Errors: Msg 102, Level 15, State 1, Procedure GetWorkingDays2, Line 4 Incorrect syntax near ')'. Msg 178, Level 15, State...

I need to write an SQL Function (UDF) to find the First Day (int) and the Last Day (int) when I specify a date. For example: When I specify (20130217) (i.e. Feb 17th, 2013), I should be able to find the First Day (01) and the Last Day (28) for the specified month (in this case, Feb). How can I do that? Please provide the necessary code to...

I have created a database with two fields "EmpID" (int) and "LeaveDate (DateTime) using SQL Server 2005. How Do I modify the below Stored Procedure to find the total working days for an employee in a specified Month and Year(Eg: August, 2012)? The Total Working Days is as follows; Total Working Days = (Total days in a month) - (...

I have an SSIS package that fails intermittently since 2/18/2013(Monday) mt production Server. The SSIS package accesses excel files on a shared folder. SSIS package has been running successfully for 30 days until this week. SSIS package runs successfully 3 times then fails. Then run again SSIS package runs successful. Below is error: Executed...

my table has a columnn 'name', I want to find only the name are more than 25 characters; I did this, but it doesn't work; can anybody help me with that. thanks; where max(len(ltrim(rtrim(name)))) > 25

Hi, how I can create a column with case when I need another case in "then"; here is my problem: fyi, tyear is 4 diget and year is 2 diget; what I'm doing wrong? = case when isnull(t.status,'') <> 4 then case when rigth(t.,2)< rigth(t.,2) then when t. <= 12 then '20'+t. else '19'+t. end else t. end

I have 90 scripts in C:\SQL Scripts\*sql how could i execute by command ,i saw many things on net but could execute it successfully,,, I am using sql 2008 R2 , not a default instance

I need to create a MS Word document that list all our SQL code for a specific project. I want it to be clear, readable and colorful. Any help would be gratly appreciated.

While installing sql server 2000 standard edition, how to change the default collation.

With the dates in the WHERE clause here, 5,100 records are selected. It takes the function below 3 minutes to process them. With the actual date range desired, 119,000 records are selected. Does anyone see a way to make this run significantly faster? SELECT HIST_ROW_ID, HIST_CREATE_DTM, HIST_LOG_ACT_CD, HIST_IMAGE_CD, HIST_TERM_ID, ...

I need to export data, from within a Sql SERVER stored procedure to excel. Right now we use access 2003.The procedure has selected from 2 temporary table which joined with other views in our database.This cause problems while i'm trying export data to excel.I had defined another temporary table and insert whole result into it and then select just...

I need to allow users belonging to a specific group in their machine to be able to access a specific DB. I added one group in the server and so the following group was added to the logins in the server: ACCOUNTINGSERVER\INDBUSERS But only administrator, who i made part of the group also access it. But admin's from other systems cant login at...

I can not figure out why I am getting an error. Can someone help? Here is my code with the line with issue highlighted. SET @var1 = '' SET @var2 = '' SET @var3 = '' SET @var4 = '' SELECT @Counter = MIN(ID) FROM #TEMP WHERE ID>0 WHILE @Counter > 0 BEGIN

Hello everyone! I am new to SQL and have given myself a 3 Day crash course! I apologize for my lack of knowledge. A project was assigned to me for work and so now I need to get it done. I am running SQL SERVER 2008. I have one Database. It is called "HomeHealth". It has 3 Tables. 1.HomeCareAgencies (Holds the Agency Information such as...

Is it possible to convert the following script into a view. Ultimately i would like to draw data using excel. The Script goes as follows: DECLARE @columns VARCHAR(2000) SELECT @columns = COALESCE ( @columns + ',',

Am trying to include SQL SERVER 2008 EXpress as a prerequest for my application but having difficulty installing because it got the following error: The specified credentials for the SQL Server service are not valid. To continue, provide a valid account and password for the SQL Server service. The command i am providing it is: /qs...

i have Table colled User it cantains Password Field, Normaly in Salect Query for this Table, Will retrive All data Fields in this Table and Password Field all so Displed, My qeustion is How to encrypt Password Field in Fake Data ex(********) durring Select Query! like this.. Id: UserName:Passwod

i have an ms access database nearly 200 dbs with 3 tables in each db. i want to make this ms access database to sql sever 2005 databse i.e i want to get the same tables same data in sql server. can any one help how to write a java program forthis

what is the use of this sp_addextendedproperty . when we will use and what is function or work of this command.. does it is like a symmetric key .. i search in google i did not get can anybody explain me this

Hi... I got A db in which normal tables are there and also procedures are there the thing is that in the table they didn't mention the references ... and in the procedure they are using references as this is foreign key and primary key... So my ques is how come i should understand from the procedure .... about the references... can any body help...

Hi all I need your help, how can you format a string with placeholders with the number of placeholders not known in advance (dynamic number of placeholders) ? I need to do that in T-SQL "xxxxx {0} yyyy {1} zzzz {2} " with {} replaced by parameters. I did the code:

Trying to setup my laptop as a development base for PHP. Details are as follows: Windows7 x64 SP1, SQL Server 2008 R2, (EasyPHP instalation) PHP 5.4.6, Apache 2.4.2 SQL Server is running fine as can read data using C# (in Visual Studio) PHP is running as can read data from the mysql db that comes with it.

Hi , While I am trying to import a .txt file from Linux server , I am getting this error - "The specified header or row delimeter "{CR}{LF}" is not found after scanning 65536 bytes of the file".. In the linux server I can see the file , open it and can download it to my local windows box as well. what could be the problem ?

i have deleted once sql server 2005 from control panel and from all programs also then i reinstaling thq sql server 2005 at that time i m getting error the message shows like"software is installed already" what should i do pls give me details