JackTimber (9/5/2014)

---

Thank u Cadavre for quick response.

I am sorry to pluzzel you with my requirement. But i thought of giving myself a day and try to come up with a...

JackTimber (9/4/2014)

---

Thanks for the help 🙂

since yesterday i am trying to tiled your solution to solve my problem.

As in my case there would be different user , so i...

Also, might be worth adding a "SELECT @FirstName, @LastName;" to the top of the sproc, to see how it gets passed in to SQL Server.

What is the DDL of your table?

lefevers (9/4/2014)

---

I tried a bunch a ways and can't figure this out

The FirstName and LastName values being passed in are in cyrillic text.

How do I add the N prefix in...

JackTimber (9/4/2014)

---

Hi all experts,

I am sorry to post the problem of the same type , but i am not able to logically interpret how to traverse through the queries 🙁

Please...

abhas (9/4/2014)

---

Hi All,

Scenario is like that single dept can have multiple LocationHeads, If Location heads are multiple then they should display in single column using *starting the name as mentioned...

SELECT skuid,

SUM(CASE WHEN Online = 1 THEN -SalesAmount

...

Indu-649576 (8/13/2014)

---

This code says 'Could not find stored proc'

Plz help

declare @a nvarchar

declare @b-2 nvarchar

set @a = (select 'a')

set @b-2 = (select CAST(@a...

Well then the answer should be a list of option buttons where the user should only...

hoseam (8/11/2014)

---

Hi, I have table below with data:

CREATE TABLE [dbo].[TblUpdate](

[uid] [int] IDENTITY(1,1) NOT NULL,

[AccessGroup] [varchar](50) NULL,

[ReportPath] [varchar](250) NULL)

INSERT INTO [TblUpdate]

VALUES('Banks', '/AWDBI/WORK FINALISED/AGE ANALYSIS'),

('Banks', '/AWDBI/WORK FINALISED/AGE ANALYSIS/DETAILS'),

('Banks',...

What data type is path?

Probably no better than Anthony's, but using the 8K Delimited Splitter[/url] : -

IF EXISTS ( SELECT 1

FROM...

Sebastian Zeller (8/7/2014)

---

Cadavre (8/7/2014)

---

Sebastian Zeller (8/7/2014)

---

If I understood your question correctly, this is likely also a solution you might consider -> Converting a delimited string of values into columns

(If not...

Or append 114 to your current query: -

SELECT 'plan_werte_' + CAST(REPLACE(CONVERT(VARCHAR(26), GETDATE(), 112) + CONVERT(CHAR(5), GETDATE(), 114), ':', '') AS VARCHAR(50)) + '.csv';