It's a common misinterpretation to assume ISNUMERIC() will work like "OnlyNumbers".

Here's an alternative:

DECLARE @a VARCHAR(10)

SET @a='1e10'

SELECT ISNUMERIC(@a)

IF @a NOT LIKE '%[^0-9]%'

SELECT 'numeric'

ELSE SELECT 'not numeric'

You could also search this site...

If you're able to remove the dashes prior or during insert it will work independend of any language setting, since SQL Server will identify '20100625' as YYYMMDD.

Could you describe a...

You're welcome 😀

The concept is called "CroosTab" (see the related link in my signature). The next "level" would be DynamicCrossTab that allows you to create a matrix with flexible name/number...

There's a difference between "connecting" and "using" SS2K8 with SSMS 2K5.

You can connect to the db. You can even use a query window and query SS2K8 tables as long as...

Just being curious: What's the reason to disallow a change of language settings? Care to share an example? If it's due to using DATEPART(week/weekday) or @@DATEFIRST we might be...

Nilssond (6/24/2010)

---

I do not need to aggregate any data, just display the data in historical order. This issue is that each subcategory may have more detail lines than the...

Please provide table definition (DDL), sample data and expected result based on the sample in a ready to use format as described in the first link in my signature.

Also, please...

Something like this?

SELECT

EmpNo,

EmpName,

Adate,

MAX(CASE WHEN Reader='I' THEN Atime ELSE NULL END) AS TimeIN,

MAX(CASE WHEN Reader='O' THEN Atime ELSE NULL END) AS TimeOut

FROM #Log_Transactions

GROUP BY EmpNo,EmpName,Adate

Please provide table def and sample data in a ready to use format together with your expected result and what you've tried so far. For details on how to post...

Posting your problem in multiple threads doesn't only waste resources, it also slows down the time until you get an answer that will actually solve your issue (especially if it...

Duplicate post. Please reply here.

If you want to generate the names based on the value of Begin_Journey_Date then you could include the following lines in your union statement:

SELECT 'Q'+ cast(datepart(quarter,Begin_Journey_Date) as char(1))+cast(datepart(year,Begin_Journey_Date) as...

I'd like to understand the business case rather than doing an interpretation of SQL code...

But by looking at mister.magoos latest code snippet it seems like he's on the right track....

Ram:) (6/22/2010)

---

Hi Lutz,

I didn't get you completely.. as per my understand i think your are asking about ORDER BY TYPE and your taking top value from that..

If it is so.....

Thank you for clarification regarding the SQL version you use.

Would you mind answering the question in my previous post (order of appearence)?