Viewing 15 posts - 1 through 15 (of 111 total)
Jeff Moden (5/15/2012)
I'm not sure why this article is getting such low marks.
I would guess it may be because of the more sensationalized headline for the article. Also from a...
May 15, 2012 at 8:13 am
Sean Lange (3/29/2012)
Of course your join also has nothing to actually join tableA and tableB. :w00t:
Thanks for confirming.
I simplified the query that is in there but this had me pondering...
March 29, 2012 at 2:51 pm
Your query doesn't seem right and it's invocation too. It has nothing to do with ISNULL or the GROUPBY clause.
Some discrepancies I can see from your post
a.) Number of parameters...
March 2, 2011 at 9:14 am
ichiyo85 (2/23/2011)
1. make a SQL query box on a page so that it links to the database and users can make their own queries from ASP. Is that possible?
Since we...
February 25, 2011 at 11:32 am
This is what I do. For the component I would trap the OnError event and put a Script task. The script will essentially copy the error message into a user...
February 24, 2011 at 3:18 pm
I second @leo.Miller. In one of my queries the performance radically improved once I replaced a table variable with #temp table. From what I remember, I was trying...
February 24, 2011 at 2:57 pm
Hugo Kornelis (9/1/2010)
Oleg Netchaev (9/1/2010)
select dateadd(day, datediff(day, 0, current_timestamp), 0);
Why faster is because how datetime is stored internally (4 bytes for number of days from zero date and 4 bytes...
September 1, 2010 at 12:58 pm
cengland0 (8/13/2010)
Technically, it was version 6.50.339 that fixed the Y2K issue. Then,...
August 13, 2010 at 9:07 am
For a sample data with 60 rows and 31 columns
...
August 10, 2010 at 10:07 am
scott.pletcher (8/9/2010)
select dataId, code, imageName, min(loadid)from @t1
group by dataId, code, imageName
I have to admit it didn't occur to me that grouping will work.
I would assume since the "group by"...
August 10, 2010 at 9:19 am
transfering (8/10/2010)
merge into MonthsImports MI using (select...) I on MI.id = I.id
when matched then update set MI.id = I.id ...
when not matched then Insert MI.id... values(I.id...)
I dont...
August 10, 2010 at 8:09 am
bteraberry (8/9/2010)
While you can't do that in 2K5 in one specific SQL statement, you can do both within one block of code in a stored procedure.
Agreed; didn't want to...
August 9, 2010 at 1:10 pm
Thank you for weighing in on the idea.
The 60 columns will never be in a single table; they are spread across 6 tables with one having 5 columns and the...
August 9, 2010 at 1:08 pm
Thanks Kingston.
I was mulling over the use of RANK & Partition By, the only thing that held me back was the number of columns I would have to put in...
August 9, 2010 at 12:35 pm
Mike Menser (8/9/2010)
Jan 6 2005 9:45PM
I could be able to convert this varchar column to a datetime column now that I have...
August 9, 2010 at 12:01 pm
Viewing 15 posts - 1 through 15 (of 111 total)