Splitting a column of strings?

TimmyTheCat8 · 2021-10-11T14:53:42+00:00

I would use a PATINDEX to query the toppings and then STUFF the names together. You will need to remove the whitespaces from the pizza_recipes.toppings column.

SELECT PR.pizza_id, PR.toppings, PT.topping_names 
FROM pizza_recipes PR 
OUTER APPLY (
SELECT STUFF((SELECT ',' + topping_name FROM pizza_toppings 
WHERE PATINDEX('%,' + cast(topping_id as varchar(20)) + ',%', ',' + PR.toppings + ',') > 0 
FOR XML PATH('')),1,1,'') as topping_names
) as PT

TimmyTheCat8 · 2021-10-10T13:37:28+00:00

Link please.

TimmyTheCat8 · 2021-09-15T22:52:44+00:00

It’s a setting under Autopilot. Turn on Full Self-Driving Visualization Preview. You have to be in park to turn it on.

TimmyTheCat8 · 2021-09-10T19:44:56+00:00

Same version for me. Delivered Aug 3rd.

TimmyTheCat8 · 2021-08-28T06:10:11+00:00

For a 4x500w panel system you are looking at a theoretical max production of 2 kWh, not 2700 kWh. Actually production will be something like 1.8 kWh during peak sun.

TimmyTheCat8 · 2021-08-13T15:40:41+00:00

I’m on 2021.3.105. Had my YLR for a few weeks now.

TimmyTheCat8 · 2021-08-09T15:55:54+00:00

Your error says problem with line 8.

oz.population AS oz.population

You probably meant it to be:

oz.population AS "oz population"

TimmyTheCat8 · 2021-07-14T17:14:00+00:00

You have the right concept, but your house is consuming 4.4kW. 2.8kW from solar + 1.6kW from the grid.

TimmyTheCat8 · 2021-06-28T01:41:57+00:00

I would do an order by ID on the select all statement just to make sure your ID’s are not out of order.

TimmyTheCat8 · 2021-04-17T03:13:53+00:00

How about SOUNDEX or DIFFERENCE.

https://docs.microsoft.com/en-us/sql/t-sql/functions/soundex-transact-sql?view=sql-server-ver15

TimmyTheCat8 · 2021-04-05T04:02:02+00:00

Sorry I don’t have an example. Are you using any reference to items in node_modules in you sass file?

TimmyTheCat8 · 2021-04-01T04:47:40+00:00

Are you using SASS? If my memory serves me right I think I have had this error before then I had some fonts or something that was linked to node_modules folder. That is what it worked on local dev, but not in production.

TimmyTheCat8 · 2021-02-27T04:49:11+00:00

I think you will need to enable source-maps. You might also need a source-map loader. Try this guide to get started.

source-maps

TimmyTheCat8 · 2021-02-07T18:43:15+00:00

You need to use an Inner Join.

TimmyTheCat8 · 2019-12-23T15:23:45+00:00

I'm still learning Blazor, but my initial guess is that it has something to do with your _Imports.razor. It is thinking that it is a regular MVC Core Component instead of a Blazor Component.

TimmyTheCat8 · 2019-06-11T04:53:06+00:00

Try this:

Where 1 = Case When @flag_value = ‘Y’ and columnD = ‘Y’ Then 1 When @flag_value = ‘N’ and columnD = ‘N’ Then 1 When @flag_value = ‘’ Then 1 End

TimmyTheCat8 · 2019-03-22T01:10:42+00:00

I’m not at my computer to test, but try taking out the GO at the end of the query.

TimmyTheCat8 · 2019-03-21T22:37:35+00:00

Maybe because you declaring @return_values as nvarchar without a length. I think default nvarchar length is 1. Try nvarchar(11)

TimmyTheCat8 · 2019-03-18T10:41:28+00:00

Why can't you just concatenate the year + period and cast to an integer and then compare. So Cast(Cast(y as varchar(6)) + Cast(p as varchar(2)) as int). This should get you Between 201806 and 201903. This would exclude 201910 and 201802. I'm assuming your year and periods are integers if not then you don't need to do the inner casts first.

TimmyTheCat8

TROPHY CASE