Ludo-1135998 (8/31/2010)

---

Hi

I have a Cube with a "Count" Measure. This works well and tell me how many rows are retrieved when I perform Queries, ...

I also have a few dimensions...

balaji.ganga (8/31/2010)

---

Hi Siva,

select 'insert into sam(Id,Name,type,Email,Versionnumber)

values(' + ""id""+','+""Name""+','+ ""type""+','+""Email""+','+""Versionnumber""+ ')'

from sam

when i ran the above query.. the following error occurred

cannot use empty objects or column names.Use a single space if...

??

I'm beginning to think I should reload the page before posting 😛

Would need to be dynamic SQL, e.g.

DECLARE @sql AS VARCHAR(MAX)

SELECT @groupname = 'domname\userid'

SET @sql = 'CREATE USER ' + @groupname + ' FOR LOGIN ' + @groupname

EXEC (@sql)

Damnit Lowell! 😛

balaji.ganga (8/26/2010)

---

Hi All,

How to generate a insert query script in sqlserver 2000. In Sql server 2000 don't have option to

generate a script.

...

Cross post -> http://www.sqlservercentral.com/Forums/Topic973282-5-1.aspx

(I've answered you in your original post)

No. And there's no need for it to either. Generally, if you've got a CTE that exceeds 100, then you've got a circular reference...

Yeah, agreed. If...

okkko (8/25/2010)

---

skcadavre (8/25/2010)

---

That's a bit better 🙂

OK, what do "movings" and "stock" represent? Is movings the sum of the "quant" per day for each brand/outlet? Then stock the running total...

That's a bit better 🙂

OK, what do "movings" and "stock" represent? Is movings the sum of the "quant" per day for each brand/outlet? Then stock the running total of the...

From what you've given us it's difficult to help, can't correct your code can just point you in the right way. Looks like you're missing a FROM clause to...

thava (8/24/2010)

---

thanks to your snippet hopes finally i found a way to solve it

i tried this snippet pretty close to me the resultant show all the records with the...

--Sample table

DECLARE @TABLE AS TABLE(

[RID] INT,

[EMID] INT,

[In Time] DATETIME,

[Out Time] DATETIME)

--Insert sample data

INSERT INTO @TABLE

SELECT 62, 12, '2005-08-18 06:02:00', '2005-08-18 06:31:00'

UNION ALL SELECT 63, 12, '2005-08-18 06:31:00', '2005-08-18 06:33:00'

UNION ALL...

If there are quotes around all of your data, try this.

Otherwise, try

REPLACE(NAME, "\"","")

If that works, then the problem is with "Upper", so you could set a derrived column that first...