Microsoft SQL Server Forum

Many way try but can not convert my MAC outlook EML mails into Outlook PST file format. Now i am worry about my important mails please provide any solution for type of problem.

I want to ensure every serial number in a table has the same amount after each update to avoid a situation where the same serial number holds different values in different rows . CREATE TRIGGER myupdate (a,b) AFTER INSERT ON myTable FOR EACH ROW BEGIN SELECT a=lastInsertedAmount SELECT b=lastInsertedSerialNumber END

(select '99999' as , /* the rest of the codes */ out put : <ram:ID> 99999 </ram:ID> but what i need is :

Hi, in my SQl database, I have a WHERE statement to search a record based on two dates. using the code below, Query will not return a record if SearchDate=FromDate. Amongst my records, an example date range in database is: FromDate = 2014-04-10 17:32:55.000 ToDate= 2014-04-16 17:32:55.000 Search fails for 10/04/14. Other dates...

Hi, I have a situation where the customer wants to virtualize all their SQL Servers. They have medium sized databases and are a smaller company. The problem is the customer does not know which virtualization tool to use. I am not an expert on virtualization, and they are having someone else set up the servers. I started to think, how negatively...

Hello All, I have a table SQL Server with one column.The column name is 'Name'. This column contains names of some persons.(as shown in figure 1) So by using those names i want to get the output as each letter as an individual column.(as shown in figure 2) If this is possible please guide me how can i get this....

The following SQL code works fine if I don't use the CONVERT to make my column two characters wide. When using it as follows the error message reads: "ORDER BY items must appear in the select list if SELECT DISTINCT is specified." If I just use: SELECT DISTINCT MONTH(CTNoteDate) it works fine. How can I run this query with the column...

I have successfully got my SAS data into SQL Server, but all of the data appears to be left-aligned, even numeric values. Is there a way to re-align the data so it is consistent with SQL data?

Hello all this is my first post. I am trying to strip some unwanted text from a column containing department names. This first query strips all characters after the colon in the name: SELECT CASE WHEN CHARINDEX(':', DB.Table.DEPT)>0 THEN LEFT(DB.Table.DEPT, CHARINDEX(':', DB.Table.DEPT)-1) ELSE DB.Table.DEPT

How to follow the stored procedures naming conversation in mysql.

I am using the below query to search some text in a sentence declare @a nvarchar(100) set @a=N'%' declare @b nvarchar(50) set @b='public property' select @b where @b like '%' +@a+'%'

I'm probably making this harder than it has to be, but here is what I'm trying to do. I have created some functions in vb.net and then imported those functions as an assembly. I then created a UDF to be able to call those functions in the assembly. These functions require two arguments. The first I can pass to it as I call it. The second one...

Hey guys, so what I'm trying to do is run two queries (keep in mind, there may be a better way to do this) to basically return a result of count = 0 or count = 1 #1 select * from person where username = 'username' From this query I want to get the users ID from the result. The column name is simply "id". I then want to use that ID in query...

My Code as below: ID,CustomerName,Customernumber,Type,Model,Serialnumber,PhoneNumber,Email,Country,SOW,Qty,InstallationDate,WarrantyExpiryDate,StopdateinCalculation,productDescription,GrossMaintenanceprice,YearMonth,ServiceTierlevel,SLAlevel,Location,NrofDaysincontract,TotalGrossMaintenanceamount,Yearamount,Netamountperperiod) @ID int,...

the short version: I need to explicitly set the port for my linked server config to use only port 1433, and can't figure out how to do that. Has anyone done this before? the long version: I have two data servers on different subnets (xx.ab.cd.59 and xx.ef.gh.59)hosted by a third party and several client machines on each subnet that need to...

Hello all, Previously in my 'date' column the values are like below. Date ------ wed o5/23/2013 fri 03/20/2014 ------------ ------------ etc......

Hello all, I am trying to query the minimum datetime from a column that is stored as nvarchar(max). There a a few tricky things with this query (at least for me) - There is more than just the date being stored within each record. -The position of the datetime is relative- although it does always appear in the format '**(DD-MM-YY at HH:MM...

Hello all, I have a table in my sql server with column name as'type' and 'Direction' (as shown in image 1). and from this input i want the output as below once. (as shown in image 2). Thanks In Advance, Phani Kumar.

Hi. SQL back end Access front end. I have a table that contains a phone number field. It has a mask so the phone numbers will have () around the area code. I ran a stored procedure to export some of the demographic fields in that table and some records are not showing the () around the area code while they appear like that on the form the user...

Hi, Same old problem I see everywhere but dont quite get the solution. I have this query. keywords_cmd.CommandText = "SELECT city,galleryimage1,galleryimage2,galleryimage3,galleryimage4,galleryimage5,galleryimage6 FROM databasetable where city like '%" & Request.QueryString("term") & "%' and galleryimage1<>'' and galleryimage2<>'' and...

Hello all, I have a table in sql server.The Layout is as below.(image1) And i want the output as like below.(image2). Please guide me,how can i do for this. Thanks In Advance, Phani Kumar.

Dear All, I want to create a view and the view only should get those rows from a table which a dateColumn has in this format(MM/DD/YYYY) this date(XX/20/XXXX) date for every month if the date is 21 in the view should not show that record, means for only one day the view should hold/keep the record. thanks in advance.

I have this first query which gives the mimetype and sum of their total datasize and count of number of document SELECT MimeType, SUM(DataSize)/1024 as Total_Size_MB,count(DocID) as Total_No_Doc FROM DVersData group by MimeType This second query gives the latest version of every document type SELECT DocID , MAX() AS FROM ...

I have table having column which stores documentid and another column storing the version of document.I want query to find out the only the latest version of document? can any one help

I have a set of data that has two dates for each row. The second set of dates is repetitive in some cases. I only want the last(MAX) date retained for this second set of dates. The raw data shows: ID Date1 Date2 312 1/12/2013 1/18/2013 312 1/12/2013 1/29/2013 312 1/21/2013 1/29/2013 312 1/25/2013 1/29/2013...