Recent content by Kenos

Using the Master database is there a way to return a value if a table exists in a different database. Any help would be great. Currently I am trying to get it this way. DECLARE @vCharDatabaseName varchar(255) SET @vCharDatabaseName = 'MyDatabase' /* @vCharDatabaseName is passed into the SP...

Toga, Post you request to FEDEX test server https://gatewaybeta.fedex.com/GatewayDC You will need to fill in your FEDEX account information below and package info. hope this is what you need. <?xml version="1.0" encoding="UTF-8" ?> <FDXRateAvailableServicesRequest...

Place a double quote at the end of your statement.

For everyone out that may need to do this In SQL Management under Jobs Created Job Step 1. T-SQL Script Use Master DECLARE @result int EXEC @result = sp_detach_bd '<name of database>','true' If (result = 0) PRINT 'Success' ELSE PRINT 'Failed' SETP 2. T-SQL script Use master DECLARE @result...

Issue: I have a MSDE SQL database that needs to return it to the original state after it is shown to customers. I would like to create a job that will Detach the database, Copy the .mdf and .ldf file from a backup location located on the same machine Attach the database. Question: If I use...

Hello Everyone I have over 130 databases that are exactly the same, (Different Data) I need to drop a Column in a single table table = Products Column = Old_CAT_ID Is there a way to create a stored PRoc to cycle all databases and drop just one Column Thanks

Thank You for your response dky1e When I first tried it it returned a null value Then I added this to it declare @names varchar(256) Select @Name = '' select @names = @names + ItemName + ',' from table select 1 As ID, @names As Items And it worked Great Thanks for all your Help (Mental...

Hello Every one, I have a table that has four records in it ID, Item , ItemName Values 1, type1, Name1 2, type2, Name2 3, type3, Name3 4, type4, Name4 Output Needed Is this ID, ItemName 1,'name1,Name2,name3,Name4' Thanks in advance Any help would be greatly appreciated

Thank you fluteplr

I have been writing a DTS package using the Eval Version of SQL The trial period has expired and I cannot install a full version on my Windows Pro System The Question is: Can I retrieve the DTS Package from a file to import into my Full Version of SQL?

Thanks Zhavic This Function works Great Thanks for the Help

I have phone numbers in a nvarchar(20) Column I need to remove all Non numeric Characters and remove extra number leaving a 10 digit number Is there to replace using like % a-z % This is what I am using now CONVERT(...

V_SQL = V_SQL & &quot;RTrim(LTrim(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((SELECT ParentName From CategoryParentLookUp WHERE Product.CategoryID =MainID),',','<\Co>'),CHR(34),'<\DQ>'),CHR(13),''),CHR(9),''),CHR(10),''))) AS MainCategory From PRODUCT I get this Error. Undefined function 'REPLACE'...

Thanks you very much swampBoogie, Now I can enjoy the weekend

I have one table that holds Billing and Shipping information There is a Bit set to true if the Billing is the same as the Shipping Here is what I need to do If Bit = true Show shipping info If Bit = False Show billing info Fields are BillingFirstname ,BillingLastName, ShippingfirstName...