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...
-
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?
-
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.
-
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...
-
RE: adding rows to a table with an identity column
Erm... me? Does that count?
-
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...
-
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,...
-
RE: Comma Seperated Value seperation
If I had a penny for how many times this is requested...
--This SQL script is safe to...
-
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?
-
RE: Problem with query
I don't much like it, but here's one possibility...
--This SQL script is safe to run
-
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?
-
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...
-
RE: Concatenating results from two result sets
Hi Dionisis,
Something like this perhaps?
--This SQL script is safe to run
declare @t1 table (userlogin varchar(30), address1 varchar(30), address2 varchar(30), telephone varchar(30), zipcode varchar(30))
insert @t1 values ('aadamx02',...
-
RE: DB Design issue - Foreign Key
Call me crazy
, but I'd do this the normalised way (i.e. with no clientId in the documents table) until I found a good reason...
Viewing 15 posts - 586 through 600 (of 683 total)