There seems to be something a little odd going on. I agree that from what you have posted creating a temp table as a copy seems like complete overkill. Have...

I will second Phil on the NOLOCK. That query hint is by no means a go fast pill. It is a get your data quick as long as you don't...

No problem. I have been bitten by that one myself. Glad you got it working.

jonesg 74626 (12/14/2012)

---

I've used INSERT INTO...SELECT many times but as "SSCoach" answered above on Nov 22 the query solution to my problem is complex. This is the SQL Query I...

A quick google search of your message shows that this is very frequently caused by having a bit field in sql that has no default. Do a search for "write...

So make the query...

jonesg 74626 (12/14/2012)

---

One more question, new dataset - similar problem... it is possible to extend this solution and now INSERT this query into another table?

Take the query (simplifed):

With BaseTable AS...

Kumar SQL (12/14/2012)

---

Hi,

I have a sql data need to export to xml file; I can get data in xml mode using FOR XML PATH query and results are shown in...

Nice article. Will keep that one bookmarked to help explain the size issues encountered with heaps.

You could do it a little easier with some string manipulation.

;with cte (val1, val2, val3)

as

(

select 'asdf', 'qwer', 'rtyu' union all

select 'as.df', 'yt', 'hhg' union all

select 'weret', '99t4.rtkg9', ''

)

select case when...

dragosgrigs (12/14/2012)

---

Thank you for this but the problem is that I'm working with a table that has over 80 columns and I was thinking if there's an different, easyer way...

SQL SERVER ROOKIE (12/13/2012)

---

Hi Sean,

I have been told that table A and B are related (2 columns from table A have to be concatenated to form a...

There are a few other versions similar to the script above that have been posted around this site repeatedly. The code posted looks like it should work but the poster...

SQL SERVER ROOKIE (12/13/2012)

---

Hello fellow developers,

I have been trying to look for a column in a table A for joining it with other table B . I'm not sure...

This works for me.

create FUNCTION [dbo].[fn_MyFunction]

(@ID INT)

RETURNS @return_table TABLE

(Col1 int NULL,

Col2 int NULL)

AS begin

--- processing goes here...

INSERT @return_table

...