Programming SQL

Does asynchronous operation supported by oledb provider for openquery?
I want to develop an oledb provider for distributed data collection via network. The result rowset is forward readonly and dynamic collumns. Because return data is time consuming that asynchronous populate is needed. My question is: 1 Does asynchronous operation is supported in linked server for custom oledb ... 9 Jun 2010 18:43

Query question - Separating Columns?
Hi, I am stuck with a programming problem and I'm wondering if anyone can help me. Running SQL 2005. Here's a sample of my data: CREATE TABLE #temp (class varchar(1), referral varchar(2)) INSERT INTO #temp VALUES ('A', 'BB') INSERT INTO #temp VALUES ('A', 'AA') INSERT INTO #temp VALUES ('B', 'B... 8 Jun 2010 18:23

Cast Varchar to Decimal?
I have this value (it's a VarChar(36)): 9.981884727716366E-4 If I cast it as Float and then Decimal(36,24) I get 0.000998188472771640000000 Note the rounding. I don't want ...64 I want ...6366 How can I make that happen? Thanks. ... 9 Jun 2010 17:36

Question about stored procedures - please advise.
Hello SQL Monsters If a stored procedure exists as complied code on my server then why would you drop a procedure and then recreate it? Doesn't this delete the execution plan? If so, is there a programmable way to create a procedure only if one is not found otherwise alter the procedure? Thanks in advance, MC ... 8 Jun 2010 18:23

Begin and End Block in an IF statement
I have seen in a couple of places that the use of begin and end block in a single statement is discouraged Outside of extra 2 lines of code, is there an issue in enclosing a single statement with begin and end block? Thanks in advance ... 8 Jun 2010 14:54

Strip the first byte from an image column.
The application language that I use prepends # (0x25) on the front of image data before storing it in SQL server. It handles this natively, and can display the images 'directly' from the entity, internally. However, I'd like to make use of them in Crystal reports. I have tried casting the image column to va... 8 Jun 2010 17:15

Purple Indulgence——ghd new limited edition color collection
The gorgeous new limited edition colour collection from GHD is on the market ! This collection is designed for all hair-lengths. The lowwest price with 60% discounts and Free shipping! There are more surprises waiting for you！ The global hair brand makes you to be next fashonista.Come and choose your destiny ... 7 Jun 2010 22:12

Selecting Maximum Values in a Query with joins to other tables
I'm having difficulty with a query and hope someone can help me out. Basically, I'm looking to select the maximum amounts from a table based on a column in one of the tables named StateID. It works fine when I do this: SELECT TOP (100) PERCENT dbo.Bids.StateID, MAX(DISTINCT dbo.Bids.Amount) AS Amount, ... 8 Jun 2010 03:40

Selecting Top Records from Subquery
I'm creating a table that will store which products where viewed also viewed on a website. Basically it will hold the needed info to produce the "customers also viewed these products" that you see on sites like amazon. The below ddl displays an example and returns which product id's where viewed after viewing ... 7 Jun 2010 15:30

Try Catch to Pinpoint Set-Based Error?
SQL 2008. I have a fairly simple Merge statement with this: When Not Matched Then Insert Values ( ... long column list ... cast( crazyCol1 as decimal(16,8) ) / 1000000 ) , cast( crazyCol2 as decimal(16,8) ) / 1000000 ) cast( crazyCol2 as decimal(16,8) ) / 1000000 ) cast( crazyCol2 as decimal(16,8) ) /... 9 Jun 2010 22:02