Microwave

wiener mobile

eh.shams (7/10/2012)

---

please attention , these are variable not aggregation function, i chenge it name to ali

SET NOCOUNT ON;

Declare @90000119 varchar(8),@ali varchar(50)

Declare @cslPricingFactorRef varchar(3),@Avamel varchar(50)

SET @90000119 = 0;@ali=0

Declare spid_List2 Cursor FORWARD_ONLY...

Taking a wild *** guess here and wondering if its because when using the synonym the query optimizer does not see the index on the view?? not sure why...

on some of our ETL loads we have a staging database with an initial table. we then run data validation and insert into a second staging table then insert...

it depends. way to vague to really answer. can you post a more detailed explanation and some DDL, Sample data, and expected results?

See the first link in my...

what is the exact error you are getting. if you were getting no errors with the code you posted the changes to the code should not have caused any...

Munabhai (7/2/2012)

---

Hello Friends,

I have employee table which is in sybase, which looks like

EmployeeIDEmpName Salary State

1 ...

Bill Talada (7/2/2012)

---

@ Lynn Pettis

I don't remember you posting code for your 8k splitter. We all knew there was a general splitter function being used. It doesn't matter...

eagb (6/28/2012)

---

Yes you are correct it's part of the trigger. Thank you for helping me see that! Unfortunately I can only suggest they change the linked database so most likely...

StephenNL (6/28/2012)

---

@capn.hector

Yes, I have attached the db on a non productive server in Hyper V (of course).

The result was a language-collation error when attempting to add users (schemes).

So, instead,...

is this line in the trigger?? from your post i think so:

SELECT @ID=ID FROM deleted

if so the trigger looks to only be able to handle one row being deleted...

have you tried restoring a backup taken from the 2k server on the 2008 server?? i believe that should work provided you set the compatibility level correctly on the...

i dont think you need your function. i think you just need the create proceture like follows:

CREATE PROCEDURE MyProceture

@StartDate DATE,

@EndDate DATE

AS

SELECT ProducttId,

...

from your excel i can recomend you get rid of the line_on_charge table and have a composite key of charge_guid (although i may look at going to an int or...