Viewing 15 posts - 1,351 through 1,365 (of 13,878 total)
UPDATE tbl_salesactivity_new sn INNER JOIN arh ar ON sn.shipment = ar.shipment_i AND ar.ardelay > '0' SET sn.delay = 'Yes'
That is almost correct. Just need to shuffle things round a...
If you provide your sample data in a more accessible form, like this, you will probably get more responses:
DROP TABLE IF EXISTS #Transaction;
CREATE TABLE #Transaction(Transaction_Id INT, Date_Transaction...
This question is strikingly similar to this one.
Perhaps the responses you received there were not to your liking? You did not even have the courtesy to respond to the...
I need to create one table to accommodate this scenario to record the courses each worker did in each job every year.
Whoever asked you to do this needs to...
This possibly means that there is a 32-bit version of the driver installed on the server but not a 64-bit version.
I suggest you get out of the habit of writing = NULL. Instead, write IS NULL. NOT is very useful, do not discard it!
Or is there any other better way to perform this task?
Thanks
Presumably BACKUP/RESTORE is not an option.
For the volumes of data you are talking about, I'd probably use a pipe-delimited...
My goal was to help present dates in form "YYMM". Existing functions such as Convert and Format apparently are tricky to use to achieve requested format.
FORMAT is not 'tricky',...
It seems that you're not trying the suggestions here with any great application.
Instead, you appear to be waiting for someone here to write the solution for you. Unless you can...
Use something like this to generate the statements for changing DB ownership to sa
USE master;
GO
SELECT name
,SQL = CONCAT('ALTER AUTHORIZATION ON DATABASE::',...
Yikes, a WHILE loop. No wonder it's slow.
The following query should do the UPDATE in a single hit. But please test it thoroughly before running it anywhere important.
To answer your other question, CROSS APPLY is one way:
DROP TABLE IF EXISTS #SomeXML;
CREATE TABLE #SomeXML
(
Col1 VARCHAR(50) NOT NULL
,Col2 VARCHAR(50)...
Hi Phil ,
First thank you for your reply and yes it works thankyou..... you are a champion!!
Phil what is the best way to apply this logic to a sql...
Updating the column by matching on UniqueId should not take such a long time. Can you show us your UPDATE query? Approximately how many rows of data need to be...
Viewing 15 posts - 1,351 through 1,365 (of 13,878 total)