Forum Replies Created
Viewing 15 posts - 376 through 390 (of 683 total)
-
RE: Turn data output 90 degress
Here's an alternative. Ib - If speed is important to you, you might find it performs a bit quicker, but you'll have to test that yourself.
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Using GROUP BY in a SELECT statement with Multi-CASE
We can shorten the code still further. But I'm just riding Peso's suggestion...
SELECT z.[Start Date],
z.DType,
SUM(z.Volume)
FROM (
SELECT ...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Converting varchar to datetime in select statement
> ISDATE() which I think only allows US (mdy) format
I don't think this is correct. I think it works from the dateformat setting (see example below).
I agree that data cleansing shouldn't...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Converting varchar to datetime in select statement
Just to note that you can use the 'NULLIF' function too (example below). But the ISDATE approach is probably safer and better.
--data
declare @t table (d1 varchar(30),...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: help in open XML(how to overcome file size limitation)
You've not really explained what it is you're trying to do, but maybe these links will help...?
http://www.perfectxml.com/articles/xml/importxmlsql.asp
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=21&messageid=217076
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Nested/Hierarchical table query
Just to clarify: This is an 'Adjacency List Model', rather than "Joe Celko's 'Nested Set Model'".
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Stored Procedures and Arrays
It looks a little underdeveloped!
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Stored Procedures and Arrays
Arrays? Maybe this will help?
http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Set based ideas ? Cursors way too slow....
And here's a very silly method (loosely based around another one of the techniques in the link Mirko provided)...
--data
declare...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Set based ideas ? Cursors way too slow....
Hi all,
I've just come to this and, since it looked like fun, thought I'd have a stab
I've just coded for the 1st...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Funcion fn_split to work with sp_send_cdosysmail
http://www.google.co.uk/search?hl=en&q=fn_split ?
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Converting Integer to Date
...obviously to get this date to yymmdd format, you just need to use convert...
declare @i int
set @i = 1137699938
SELECT convert(varchar, DATEADD(ss, @i, '01-01-1970'), 112) as...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Converting Integer to Date
skarai has got it, I reckon. To explain more simply...
declare @i int
set @i = 1137699938
SELECT DATEADD(ss, @i, '01-01-1970') as 'My date'
/*results
My...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Populate SQL Rows from Excel Columns
Philip - I'm confused!
You said "I can import the spreadsheet into a temporary table via DTS". The 'data' section I wrote was just my test data to illustrate the method to use...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: passing variable to TOP option
Use 'set rowcount' in sql 2000...
http://www.aspfaq.com/show.asp?id=2521
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
Viewing 15 posts - 376 through 390 (of 683 total)