Also select into will throw an exception if the the destination table already exists. You do not have as much control over the datatypes when using a select into either,...

No problem. I would suggest changing to a left join instead. If you use an inner join and there is no supervisor you won't get the employee information either.

Remember that doesn't mean you suddenly have any table in your system. You have to define TVP as a type. Then you can pass that table to a proc as...

I have a bad feeling that you want to pass in your...

I assume you mean SP1? Did you try to download and install it? A quick search...

This is likely VERY close.

SELECT STM.staffcode_c as [Staff Code],

STM.firstname_vc as [First Name],

STM.lastname_vc as [Last Name],

PC.description_vc as [Program],

STM.department_vc as [Title]

STM.birthcountry_vc as [Spervisor],

supervisor.firstname_vc as [Supervisor First Name],

supervisor.lastname_vc as [Supervisor Last Name]

FROM ar.staffmaster...

Hi and welcome to SSC!!! We need some details before we can offer much assistance here. We would like to see ddl (create table statements), sample data (insert statements) and...

Alan.B (1/10/2013)

---

I agree that I should have used a tally table. I've been writing CTE's for counting for awhile and can do so while sleeping. I still fumble around with...

Hi and welcome to SSC!!! This is a sql server forum and not a MySql so the help you get may be somewhat different. The basics are the same though...

gsd1 (1/10/2013)

---

Hi,

Why the following code gives error? I have @temp table variable already declared, @p_SampleRecords variable already declared and assigned a value.

Declare @strSql varchar(max)

set @strSql = 'select top '...

Brett this is actually pretty simple. I included some sample data using your names and even included the condition of len = 6. for numbers though we don't want to...

dbdmora (1/9/2013)

---

I have a developer that wants to create 4 different databases on a specific server that what technically seems for 1 app.

ITApplicationSecurity

ITApplicationState

ITApplicationService

ITApplicationLogging

The same application will write to...

dave harris 45446 (1/9/2013)

---

Hi all

Can anyone advise please, I have a TSQL 2008r2 headache...

I'm calculating the geo distance between a previous geo point and current geo point.

The code below,...

vs.satheesh (1/8/2013)

---

Dear All

I am working in University Project.I have 10000 students physical photos in one directory...

Marlena.ibek (1/9/2013)

---

Hi all.

I have got a task which I'm working with on the moment.

I'm looking for an answer here, as this is the best place to ask questions.

Ok, I've created...