Viewing 15 posts - 2,821 through 2,835 (of 6,486 total)
John - The little abbreviated snippets just don't make sense to me. i just can't quite figure out how they're going together.
Let's start basic - try to...
June 18, 2008 at 1:41 pm
Gary - what version of SQL Server 2005 are you installing?
The initial version of SQL Server Express didn't include SSMS. If that was what you installed, you may need...
June 18, 2008 at 1:15 pm
Yes, there like is. As of right though - you're not specifying where or how you're getting @incr (you use it, but you're not retrieving /set its value.). ...
June 18, 2008 at 1:09 pm
GSquared (6/18/2008)
(Have to admit, I don't like the layout he used, but...
June 18, 2008 at 12:00 pm
I usually end up handling that in the outer select. Meaning - once the PIVOT has been done.
Something like:
select locationname,
...
June 18, 2008 at 11:39 am
drodriguez (6/18/2008)
The reason for the request is compare with other rows that there aren't any duplicate images.
Keep in mind that if the hash values of the two images are NOT...
June 18, 2008 at 10:08 am
Jeff Moden (6/17/2008)
June 18, 2008 at 10:00 am
Jeff Moden (6/18/2008)
GSquared (6/17/2008)
Matt Miller (6/17/2008)
June 18, 2008 at 9:51 am
Sergiy (6/17/2008)
Matt Miller (6/17/2008) Just need to tape the KISS principle sticky note to my forehead again....:)
Then everybody else will read it but you...
:hehe:
Actually - it was so I would...
June 17, 2008 at 10:09 pm
Jeff Moden (6/17/2008)
Matt Miller (6/17/2008)
Take a look at this article - will help describe the technique....
Man... you're right... you have been recommending this and the Tally table articles a lot!...
June 17, 2008 at 8:40 pm
As far as I recall - the same support packs you use on the server will patch the client and workstation tools. Or - just run windowsupdate and it...
June 17, 2008 at 8:35 pm
Sergiy (6/17/2008)
Matt Miller (6/17/2008)why travel around the planet when you can just cross the street...
Because travel agencies tell you so...
heh - I should take their advice...It's been a while..:)
It's just...
June 17, 2008 at 8:31 pm
Jeff Moden (6/17/2008)
Matt Miller (6/17/2008)
If the two tables weren't created in exactly the same way, you could easily end up with column mismatches.
Good point... but look again...
insert into t...
June 17, 2008 at 8:16 pm
Jeff Moden (6/17/2008)
SELECT d.Amount, ROUND(d.Amount/5, 2)*5 AS Rounded
FROM (SELECT N/100.0 AS Amount FROM TALLY)d
Nicely done, Sergiy. Ya just...
June 17, 2008 at 8:08 pm
Problem is - Hashbytes doesn't support the large data types, so it's constrained to 8K of data. Even with using a SHA1 hash (much more likely to be unique...
June 17, 2008 at 4:24 pm
Viewing 15 posts - 2,821 through 2,835 (of 6,486 total)