Programming SQL

IMEX=1 in OpenDataSource
I'm having an issue with selecting data from an Excel 2002 spreadsheet using OpenDataSource (or DTS for that matter). Excel will sometimes identify the column type as numeric and ignore all character data in the column, returning nulls instead of the data (known issue - http://support.microsoft.com/?id=194124)... 3 Oct 2005 11:01

Inline Queries Definition
hi, Can anyone let me know the exact definition of "What do you mean by Inline Queries in SQL Server?. I have heard lot of people talking about Inline Queries but when asked about the definition of that, I am not getting the exact answer for that. Regards Sudhakara.T.P. ... 1 Oct 2005 23:06

problem with xp_sendmail
Hello, I have the following problem. I use the xp_sendmail often in the SQL query analyser with the folowing script: USE MASTER EXEC xp_sendmail @recipients = 'hans.de.korte(a)verder.nl', @subject = 'Test mail', @message = 'Testmail1' << This worked OK for months. After rebooting the SQL ser... 30 Sep 2005 05:15

Standard Deviations
I want to get 1, 2 and 3 Standard Deviations from a group of data. Is there someway to calculate 2 and 3 standard deviations from an ISQL script? ... 20 Sep 2005 11:48

MSDTC error
Hi guys, Im new to SQL Server development in general...Well, I've been trying to work on an existing application that uses both ASP and SQL Server that happened to be raising an error that is logged on the Event Viewer 15 minutes after closing the browser. Here it is: Event Type: Information Event Source: MSD... 20 Sep 2005 07:02

SQL BLOB data back into a string
I'm stumped, Not sure if this is the right place, sorry if it isn't, but just point me to the right spot if not. My problem, another developer has stored some text, html, images, etc into a table field that is a blob. The problem is, in an asp.net page, I need to get the HTMl back out of the blob and int... 17 Sep 2005 17:48

Date/String format
I have a date that I need to get into a mmddyyyy format. There is no standard format to do this and I need to do this in Sql as there is no client program here. SELECT DateBeg,Convert(varChar(2),DatePart(mm,DateBeg)) + Convert(varChar(2),DatePart(dd,DateBeg)) + Convert(varChar(4),DatePart(yyyy,DateBeg)) as ... 19 Sep 2005 12:14

Random numbers
Hello all! I'm trying to create a function that returns a random progressive / regressive series of values (e.g. 11000, 11300, 11900, 12000, 12250) taking a start value, an end value and (an increment value). Can you please provide help? Until now I've managed creating the function returning the random numbers... 19 Sep 2005 04:27

Remote Query
Hi, I would like to know why SQL Profiler return the output shown below and is it possible to tune and avoid this problem? declare @P1 int set @P1=7 exec sp_prepexec @P1 output, N'@P1 varchar(255)', N'SELECT Tbl1019."Name" Col1075,Tbl1019."PhoneNumber" Col1080,Tbl1019."Pager" Col1081,Tbl1019."FirstName" C... 18 Sep 2005 22:48

Find duplicates
I have a query that I used that was based on the following query that Hugo gave me yesterday (I added CheckNumber in for the problem). I had a problem with finding duplicate check numbers in the table (voids,re-issued checks etc). It does show in my results, but out of 4300+checks it is hard to find all the d... 15 Sep 2005 18:35