To understand and Implement FileStream this might be very useful for you.

The Art of SQL Server FILESTREAM by Jacob Sebastian and Sven Aelterman[/url]

Gangadhara MS (6/25/2014)

---

Let me elaborate want i want to do.

It should consider (GOLD1 and GOLD 2) OR SILVER 1 kind of condition for the input data in order to...

Nice question. Thanks for sharing

did you check any transaction on this table ?

Glad to help.

i have adjusted the query

Note: i have commented the Order By Clause, because i do not know "[Entry Type]" from which table. To test the query result and performance...

ChrisM@Work (6/25/2014)

---

Your query has four output columns:

SELECT

ot.OperationalTypeAlternateKey AS [OperationalTypeAlternateKey]

,ot.OperationalType AS [Entry Type]

,Convert(Varchar, DateDayOfMonth)+' '+DateMonthName + ' '+ Convert(Varchar,DateYear) AS [Date]

,COUNT(*) AS [Total]

FROM

If you're returning a single...

no that not correct the

SwePeso statement explains it better

EVERYTHING that is defined as T-SQL is executed at server side.

Microsoft SQL Serve works with sets and can return data from the...

very interesting question, yes i have learned something new today. thanks Andy

i hope i understand it right, i think you are looking for how you want to design you tables to handle such one to many relation with Grades and partner,...

rama_kavuri (6/25/2014)

---

in an interview i have said that the functions are executed at the clients memory and stored procedures are executed at he server side

as long back i have read...

you can use the 2nd option, Varchar(MAX) can be used like regular varchar(50). no need to use Mutator "Wite()". keep it simple.

i would suggest that to avoid the null value...

+1

crazy_new (6/19/2014)

---

Yeah that's exactly how I have it. That's why I only use one record at a time. If I select more, it gives all of them the same increment,...

i used the same query which you originally shared like this

SET @LineNumber = (

SELECT

ISNULL(MAX(B_L_SEQ_NUMBER),0)

FROM

Patricia.dbo.BUDGET_LINE

WHERE

CASE_ID = 121

)

SET @LineNumber = @LineNumber + 1

i have used the same logic, if CASE_ID is not...