RyanRandall

Forum Replies Created

Viewing 15 posts - 586 through 600 (of 683 total)

RE: Data extraction from Multiple Tables

Hi Vandy,
I'm finding it difficult to figure out what you're asking for. Could you give us some sample data and the query output you'd want from that data? That would...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.

March 17, 2006 at 8:02 am

#627336
RE: adding rows to a table with an identity column

Absolutely!
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.

March 17, 2006 at 7:15 am

#627304
RE: adding rows to a table with an identity column

You're kidding me
Height, weight, shoe size, religion, date of birth, birth place, marital status, penis length...
Need I go on?
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.

March 17, 2006 at 7:01 am

#627300
RE: adding rows to a table with an identity column

I don't know about identifying me, but I have loads of attributes which help to describe me. I'm pretty sure I do, any way.
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.

March 17, 2006 at 6:50 am

#627295
RE: adding rows to a table with an identity column

Come on, Sergiy, there's more to me than my passport. You can do better than that...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.

March 17, 2006 at 6:33 am

#627285
RE: adding rows to a table with an identity column

Erm... me? Does that count?
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.

March 17, 2006 at 6:22 am

#627275
RE: Problem with query

Thanks dobrzak
I'm not convinced there's not a more elegant/efficient approach - that's just the best I've thought of so far.
Since your table is...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.

March 17, 2006 at 5:37 am

#627261
RE: Is there a way to write this in SQL

Hi all,
Just to appy alzdba's example to your situation, Doug...
--This SQL script is safe to run
declare @t table (ColA int,...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.

March 17, 2006 at 5:22 am

#627256
RE: Comma Seperated Value seperation

If I had a penny for how many times this is requested...
--This SQL script is safe to...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.

March 17, 2006 at 4:57 am

#627250
RE: adding rows to a table with an identity column

Sergiy - does a table with a load of columns imply that it's not normalised?
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.

March 17, 2006 at 4:43 am

#627247
RE: Problem with query

I don't much like it, but here's one possibility...
--This SQL script is safe to run
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.

March 17, 2006 at 4:35 am

#627241

RE: Problem with query

Having said that, I've just noticed that some of the 'dates' are invalid dates (such as 31 Feb). Dobrzak - can you explain?

Ryan Randall

Solutions are easy. Understanding the problem, now, that's the hard part.

March 17, 2006 at 2:58 am

#627216

RE: Problem with query

Vladan - how can you tell this is a varchar column, and not just different date settings? I'm in the UK, and dobrzak's posting is exactly how I would see date columns...

Ryan Randall

Solutions are easy. Understanding the problem, now, that's the hard part.

March 17, 2006 at 2:53 am

#627215