Good question about a frequently unknown topic. I guessed wrong because I couldn't decided the slant the author was using. I figured if I said it was possible because of...

I would have to agree with Greg. This design is horrible. You really need to read up on normalization. This whole collection of tables could be a single table. The...

lonhanner (12/19/2012)

---

Please Check This query for me.

CREATE TABLE NEW_DETAILS

(

TD_NUM int identity not null,

TRIP int not null,

RIDER_NO int not null,

LNAME nvarchar(20) null,

FNAME nvarchar(20) null,

PROV_CON int null,

APT_TIME time(7) null,

PKUP_TIME time(7) null,

TD_REMARKS...

anuj12paritosh (12/19/2012)

---

hi All ,

I have a table and columns with data is mention below :-

Table :- ORDER

COLUMN and values :-

...

anthony.green (12/19/2012)

---

Welcome to SCC

Can you please follow the links in my signature to posting, code and data for the best help and also the how to post performance problems so...

Or if you want a completely t-sql...

Hi and welcome to SSC. It is pretty difficult to provide a detailed answer for your question without speculating quite a few things. You might want to take a quick...

This seems to be a carbon copy another post from just a couple days ago.

http://www.sqlservercentral.com/Forums/Topic1395812-392-1.aspx

Nisean (12/18/2012)

---

thank you for the response. FYI this is not a homework or an interview question. i know how to create a table and insert data on it! i need...

Take a quick look at Lynn's article about some common date lookups.

http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D

zilla (12/18/2012)

---

I finally got around to trying some of this stuff this morning. I figured using the IF EXISTS should be pretty easy to put in place.

Here is the...

SoberCounsel (12/18/2012)

---

I knew by suggesting it that a few eyebrows would probably be raised!

Thanks Sean, for adding the links to further info about the nolock hint... as it...

sqlrd22 (12/18/2012)

---

Hi,

I currently run a query daily and have to results going into a table using insert into.. select...

The problem is, this puts all the results of the query into...

SoberCounsel (12/18/2012)

---

I'd investigate adding the "with(nolock)" hint to your query - it doesn't involve killing processes, and it might solve your problem if it's being caused by an errant lock...

gheinze (12/18/2012)

---

Hi all,

I search a lot for this issue but I can't realize what happen.

The case is, randomly (no very often, but last two weeks happend) we experiment problems...