a_ud (11/23/2010)

---

Hi guys,

Thanks to all, but I'm still struggling to see what the problem is (and that would really help). Structures like this:

set @sql=<whatever>

exec(@sql)

usually work in dynamic SQL (I learnt...

Watch the scope of your @Events table variable:

DECLARE @Events TABLE ([Name] varchar(120))

DECLARE @Id INT, @sql VARCHAR(2000)

SET @Id = 3

SET @sql = 'SELECT TOP 10 [Name] ' + 'FROM dbo.syscolumns '...

For ages up to 100, try

SELECT RandomAge = 1 + abs(checksum(newid()))%100

wagner-670519 (11/23/2010)

---

no, this counts the rows...

I need the information about the biggest hit rate.

When I search for 99911 both rows matches, 999 and 99911. But the hit rate of 99911...

Surely just the keys (primary keys) would be sufficient?

if object_id('tempdb..#table1') IS NOT NULL DROP TABLE #table1;

if object_id('tempdb..#table2') IS NOT NULL DROP TABLE #table2;

if object_id('tempdb..#table3') IS NOT NULL DROP TABLE #table3;

create table #table1 (col1 int,col2 varchar(30), col3 varchar(30));

insert into...

Don't think so. Try this, it's the same as yours with the little errors removed, mostly column types:

if object_id('tempdb..#table1') IS NOT NULL DROP TABLE #table1;

if...

All of us began our SQL Server lives knowing nothing at all about it and we didn't learn what we now know overnight 😉

This looks mouthwateringly good but has an eyewatering price.

Ventilation

Is this what they're calling the "Russian doll" roast?

Our DBA caught some news on...

Wishing Jack C a speedy recovery and some quality time for recuperation.

Get well soon, mate.

MonsterRocks (11/22/2010)

---

create table #table1 (col1 int,col2 varchar(30))

insert into #table1 values (1,'martin')

insert into #table1 values (2,'tom')

insert into #table1 values (3,'schrof')

create table #table2(t_col1 int identity(1,1),t_col2 int)

create table #table3 (f_col1 int identity(1,1),f_col2 varchar(30),f_col3...

MonsterRocks (11/22/2010)

---

is cursor needed for following scenario?

create table #table1 (col1 int,col2 varchar(30))

insert into #table1 values (1,'martin')

insert into #table1 values (2,'tom')

insert into #table1 values (3,'schrof')

create table #table2(t_col1 int identity(1,1),t_col2 int)

create table...