Glad that worked for you and thanks for letting me know.

raghavender.2369 (1/17/2014)

---

Hi,

My report query is having 10 unions. Execution time in SQL server is 20mins. no of records are 20,00,000.

So I have decided to do place the query logic in...

dquirion78 (1/17/2014)

---

Yean but I want to avoid to repeat PrdCmd.Prix * PrdCmd.Qte so many times. This expression is simple but if it become pretty long and I need to change...

No idea what your table name is called or what you are really trying to do here but maybe something like this? (Assuming your table name is #Something)

Select *

from #Something

where...

mbrady5 (1/17/2014)

---

Hello,

I have a request to build a random data generator for Manufacturing Inventory Checks.

Everyday, the requester would like a list of 20 locations picked randomly from a DB...

dquirion78 (1/17/2014)

---

thanks everyone for input

Last question:

I've a query(french query) WORKING IN Access but NOT in Sql Server 2012 express...

SELECT PrdCmd.NoCommande AS NoCmd

,PrdCmd.DATE

,PrdCmd.Qte AS q

,PrdCmd.Prix AS p

,[p] *

AS Column1

,[column1]...

Luis Cazares (1/17/2014)

---

Correct formatting and short table aliases should make the queries easier to read.

It's not the same to read:

SELECT [MyTable].[Long Column Name] AS A, [MyTable].[AnotherColumnName] AS B, [MyTable].[Long Column...

briancampbellmcad (1/17/2014)

---

I'm struggling with what would seem quite easy...

I have two tables tblBank and tblBook... I'm getting duplicates... any clues?

Looks like the LEFT JOIN would give me only...

I don't see what varchar(max) and/or...

We don't want to download your excel file and then have to spend another 5-10 minutes importing data. We want...

I will stress again to look at the splitter I reference in my signature....

Shanmuga Raj (1/16/2014)

---

I am unable to get result since,

My Table column is having data as stored as below in the nvarchar(max) datatype

---------------------------------------------------------------------------------

'(Type is HO) and

(Location...

There are a number of ways to accomplish this. Here is one of them.

select case when charindex('and Branch in', s) > 0 then SUBSTRING(s, 0, charindex('and Branch in', s)) else...

These are actually different things. Why do they have to match? If you are using a named instance you will never get these to be the same. What is the...

Shanmuga Raj (1/16/2014)

---

declare @t table

(

s varchar(8000)

)

insert @t

values('Location is Asia and Location is Europe and Location is Africa and '),

('(Location is Europe')

select s

from @t

------------------------------

expected result

------------------------------

Location is Asia and Location...