deepeshdhake (10/19/2012)

---

Hello,

Using the table EmpHistory, it is not satisfying all the rules. So I want to use this function as it satisfies all the rules. This is what I want:

I...

vs.satheesh (10/19/2012)

---

Hi All

In My project one table my old employees using following format id generation.Hoe to generate this sequence...

Grant Fritchey (10/19/2012)

---

Sean Lange (10/19/2012)

---

Is it just me or is the entire SSC site slow today? For me I can barely navigate anywhere. Each click is taking a couple minutes....

BOL is the best place for this kind of stuff. http://msdn.microsoft.com/en-us/library/bb510489.aspx

If...

Is it just me or is the entire SSC site slow today? For me I can barely navigate anywhere. Each click is taking a couple minutes. No other sites are...

rocky_498 (10/19/2012)

---

Some body ask this question during interview. I didn't the answer i would like to know if someone give me the answer of

this simple or tuff question.

Q) What...

You might look into table parameters too. This seems like a good candidate for one.

What you are describing is a process not an event. There isn't a book you can read and when you finish you are now able to write efficient queries. One...

ericb1 (10/19/2012)

---

Sorry, thanks for the help. The first query is from a custom SQL database, the results of the query give me this:

reviewer accountid accounttypeid...

valentina1983 (10/19/2012)

---

Hey guys ,

I'm new here and I really need your help.

I need to write a script that creates registration (for first visit to the website) and then login...

jbalbo (10/19/2012)

---

Thanks... fixed it. dumb on my part... thanks

I don't know whats going on with the nolicks, I inherited this.

to be honest, newer at this and not sure what it...

This looked like an extremely odd situation but a fun challenge. It can in fact be accomplished without loops. You have to combine a couple of techniques, both the delimited...

yuvipoy (10/19/2012)

---

Hi

I am getting the error as

declare @pi_input varchar(max)

declare @query varchar(max)

select @pi_input ='0123456'

SET @query = N'Select '+'SUBSTRING(@Input,'+convert(varchar,0) +',1)'

print @query

exec (@query)

Select SUBSTRING(@Input,0,1)

Msg 137, Level 15, State...

jbalbo (10/19/2012)

---

does anyone know what I have setup wrong here?

INSERT INTO @TEMPTABLE(TAG_NAME,TAG_DATA)

SELECT DISTINCT TAG_NAME = 'CUST_ALLFOOD', TAG_DATA =(M.GENERIC_NAME + CONVERT(VARCHAR(MAX),ca.Notes)

INNER JOIN CLIENT_ALLERGY CA (NOLOCK) ON C.OID_LINK =...

There is nowhere near enough information to be able to help here. Please see the first link in my signature about best practices when posting questions.