Yes, someone I work with still gets the daily news letters through our work email system, hence why I thought I'd try here.

Update:

I also don't even get forum notifications

interesting question but can anyone let me know why the create statement wouldn't of failed? interested to see why thats all

i think you are incorrect as from this simple example script (im using sql2005)

declare @t table(i int, x int)

insert into @t

select 1, null

union

select 3, 1

union

select 2, 1

select *

from @t

select...

Great question, made you think about the simple functions that we take for granted, even though i have never needed to use count_big

bitbucket-25253 (3/3/2010)

Remember that this should be a group of professionals, and trash talk is not appropriate, nor appreciated by those of us...

After researching i dont think it is a stupid question, just an incomplete question. As its a cartesian join (if the CTE is relevant im not sure!?!?)

just that...

I get an error saying tblUsers doesn't exist.. Is this a Version issue or missing information? im on SQL 2005

DOH one of the questions you pick your answer and click submit and realise you should of chosen another 😎

Great question made me remember to re - read the question a couple of times before shouting "Errggghhhh!!!"

but without SET NOCOUNT ON/OFF or PRINT it will return (1,1)

that is the issue as i ran the queries on SQL2005 std edition

if i do as the question says i get the answer 1,1

but if i do

set nocounton

select @@rowcount

select @@rowcount

i then get the answer given

I tinkered with version 7, but really used the product with version 2000 and upwards. In response to the article i would rather have a number of tools that...

Personally while learning (but you'll never stop learning!), what i did was

1. trawl the SQL server forums.. trying to see if i could answer the problems (never posted...