GilaMonster (2/18/2011)

---

I'm sorry, but unless you're written the T-SQL equivalent of the 'Great American Novel', there's nothing in your code anyone wants to steal. In my experience most of the...

If you want, then you need to keep the datatype as varchar not as datetime

declare @Var1 datetime

set @Var1='01/01/1752'

Select CONVERT(datetime,@Var1)

declare @Var2 varchar(20)

set @Var2='01/01/1752'

Select CONVERT(Varchar,@Var2)

Hi,

DECLARE @Table TABLE (Col varchar(20),Col1 int,Col2 numeric(10,2))

Insert into @Table

Values ('1',1,1),('2',2,2),('3',3,3),('4',4,4),('5',5,5)

Select * from @Table

Select AVG(Col1) from @Table

Select AVG(Col2) from @Table

Select AVG(Col2) from @Table --- must fail since...

Hi

Try this

In the linked Server properties, Server Options page, Connection Timeout (set to 0) and Querry Timeout (set to 3600);

The remote server properties, Connections page, Remote Qquery timeout (set to...

Rem70Rem (2/17/2011)

---

Hi,

We are starting to talk about migrating from 2005 to 2008. The latest version available id 2008R2, right? Do we know what are the plans of Microsoft...

Hi,

Have a look on "Distributed Queries,Accessing External Data,Optimizing Distributed Queries,Guidelines for Using Distributed Queries" in the Help File you will get some idea about it

Hi,

Any one have completed 70-451,433 if so how was the questions.

Any suggestions of how we can cover the subject.

Which part needs to be concentrate more (Generally it will be all...

Hi,

A good start is SQL Server 2008 Upgrade Advisor.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=f5a6c5e9-4cd9-4e42-a21c-7291e7f0f852&displaylang=en

You will be getting some idea.

RichardDouglas (2/11/2011)

---

How did you get on with the exam?

I sat the 70-433 exam last month and am looking to do the MCITP so I'd be interested to know how you...

Hi,

Any one has solution for the above.i couldn't find the solution elsewhere.i want to display first dataset,second dataset,third dataset,fourth dataset in the report.Anyone has faced...

Hi have a look at the below , i think you can get some idea.

declare @py table(cid int identity,fname varchar(50))-- Customer table

declare @sy table(Oid int identity,Cid int,fname varchar(50))-- Order...

Full...

Hi,

Sub-query should need to executed here but why it...

ichiyo85 (1/31/2011)

---

Hi, on a similar note, I want to make a stored procedure where I can delete customers from a December customer table, but only those who will show up...

GilaMonster (1/28/2011)

---

Especially if there's connection pooling.

Seriously, the largest number of concurrent connections I've...