@Raja mssql ,

Nothing like giving would-be hackers an advantage.  I strongly recommend that you modify your original post to NOT include your IP addresses even though it's an older post. 

Taking a SWAG at what's desired, here's the "vertical" rendition using the given data.  I don't recommend Pivoting such data anywhere but a spreadsheet and I wouldn't do it there,...

I have a table named Books and a table named Transfer with the following structure:

CREATE TABLE Books
(
BookID int,
Title varchar(150),
PurchaseDate date,
Bookstore varchar(150),
City varchar(150)
);

INSERT INTO Books VALUES (1, 'Cujo', '2022-02-01', 'CentralPark1', 'New...

Ok... when you have a ModelNameID like this...

000.001.002.000.0

... or like this...

000.160.170.000.0

... what do you want to return?

My thought is that it's a form of future computational suicide to drop the...

I'm totally lost here... where do you see a "46" in the "000.001.070.000.0"...

• This reply was modified 3 years, 4 months ago by Jeff Moden. Reason: NM. Figured it out

The error seems to indicate that the "idCategoria" column doesn't exist in one of the two tables.  Check each of the two tables to make sure that the column does...

Thanks for the feedback.

That all depends on the OP - and it isn't clear if they are looking for help with MySQL or converting from MySQL to SQL Server.  If they are...

...

Then I proved the unthinkable... I made the 99% fragmented index twice as slow by [insert drum roll here] defragmenting it!  That was a fortuitous accident that I...

I have to disagree a bit with the opening quote in the article.  My "wins" are learning episodes and so I'm always winning, not because I'm undershooting my potential, but...

I thought it was someone trying to convert some other dialect to SQL Server.  🙁  I wish people would declare things like that.  Offering help in MySQL isn't a problem...

You don't want to do that...

In tha

In that case... Do you know what a "Tally" or "Numbers" table or...

Hi SQL Gurus,

One of our production database is running very slow. I checked blocking , I didn't see any blocking. Also, check for running processes and look for any...

I had no clue but, when I did a search for it, It thought it was hilarious (or, more likely, hilari-ass) that one of the items returned on the first...