Viewing 15 posts - 13,021 through 13,035 (of 15,381 total)
Steve Doinidis (2/8/2012)
Provide the parameter in the SP?I have the parameter in my report and an integer that allows Nulls.
Well you changed your parameter to be optional.
@Address Varchar(163) =...
February 8, 2012 at 2:59 pm
If you don't provide the parameter and you have the default of null your query will only return those where FullAddress is null.
February 8, 2012 at 2:44 pm
SKYBVI (2/8/2012)
GilaMonster (2/8/2012)
Yes.Thanks.
Then these begin and rollback transactions are used for whcih TSQL statments??
Regards,
Skybvi
If you have a batch of updates for example. Maybe you need to update 3 different tables,...
February 8, 2012 at 2:11 pm
LutzM (2/7/2012)
February 8, 2012 at 2:07 pm
exec SDoinidis_Duluth_LicenseeActivity @Address = 'Some Value'
February 8, 2012 at 11:09 am
That will work if ALL your HTML is properly formatted so it can be parsed into xml. This is likely not going to be the case and properly removing all...
February 8, 2012 at 11:02 am
sunny.tjk (2/8/2012)
Could someone please tell me if the following query is correct:Begin Transaction
Delete from tableabcd where starttime < '1/1/2011'
Rollback Transaction
Well that depends on what you define as "correct". There do...
February 8, 2012 at 10:49 am
It failed because you didn't pass the parameter when called your stored proc.
February 8, 2012 at 10:46 am
Something like this?
SELECT Customer_Number FROM Customer_Offer
WHERE Product_Offer = 'Offer2'
and Custom_Number in
(
SELECT Customer_Number FROM Customer_Offer
WHERE Product_Offer = 'Offer1'
)
February 8, 2012 at 10:43 am
lonex (2/8/2012)
You were right that without the data it is hard to validate code. I will be trying to create sample data and code as per best practice...
February 8, 2012 at 10:19 am
river1 (2/8/2012)
Sorry, didn't understood you point...
This is a database about stocks (Car parts)
This parts (wheel, tires, etc...) can be located...
February 8, 2012 at 10:01 am
river1 (2/8/2012)
In the location_type you don't have just vheicules...You have three different records:
1) Cars
2) Trucks
3) WareHouse
This is where the stocks can be
I followed that. Maybe that should be Vehicle and...
February 8, 2012 at 9:44 am
I don't think you want a table for this. This really should be a view instead of a permanent table. Otherwise you have to insert/update/delete from this table every time...
February 8, 2012 at 9:30 am
GilaMonster (2/8/2012)
Sean Lange (2/8/2012)
Cadavre (2/8/2012)
February 8, 2012 at 9:22 am
Cadavre (2/8/2012)
February 8, 2012 at 9:09 am
Viewing 15 posts - 13,021 through 13,035 (of 15,381 total)