krhind (3/2/2012)

---

Also, I took a look at the post in your signature about best practices for asking question on these forums. Perhaps I am missing something though, I tried to...

sabercats (3/1/2012)

---

Sorry, i am newbie and really don't understand what you mean "Please provide some ddl and sample data along with a clear explanation of what you are looking...

just in case here it is again....works fine for me

http://www.karaszi.com/SQLServer/info_datetime.asp

...hmm..seems my version excel isnt working...

subahan_syed (2/29/2012)

---

Well. In a row value of alpha numeric code like 'E126W4SD', the above excel algorithm will provide values replacing the alphabets, based on alphabet series. Lets say an alphabet...

i have an idea that the date criteria is causing your problem...just a guess 🙂

pls confirm version of SQL

pls provide "create table script" for table [System].[dbo].[Machine_Control_History]

pls provide sample data to...

to get this output....what query did you use, specifically what is in the "WHERE" clause?

"We are going to develop a project where clients will be able to Create their own SQL tables and fields. "

Do you currently provide your clients with some form of...

it would easier to understand, if you care to provide some create table scripts and sample data ...with your expected output.

but initial thought is,

pseudo code : "WHERE end_datetime...

Vahid.Ch (2/29/2012)

---

No I don't need,it was a sample.

let me explain more.

I'll have new Database everyday,around 300,000 to 350,000 rows.

so,it stores users log,such as url,clientIP,Logtime and so on.

imagine that an admin...

take a look at this post/thread....maybe helpful

http://www.sqlservercentral.com/Forums/FindPost1071067.aspx

Hi George

I wonder if you could clarify something for me please?

say I create 5 requisitions

req1

req2

req3

req4

req5

now, I decide that i need to link "req5" with "req2"...can I also link "req5" with...

have you read this article...it may help expiain

http://msdn.microsoft.com/en-us/library/gg492088(v=sql.110).aspx

is this an example of what you are trying to achieve?

DECLARE @sample TABLE (

id INT IDENTITY(1, 1),

product VARCHAR(10),

...

alexei

One question : did you properly obfuscate the data in your attachment xml?

if not then please ask the site to remove it immediately.

If you are seeking help with something from...