Viewing 15 posts - 1,111 through 1,125 (of 1,390 total)
Sometimes spreadsheets are useful to concatenate together parameterized sql code.
="sum(case when (td.BSP >="&B7&" and td.BSP <"&C7&") and td.WIN_LOSE=1 then td.BSP end) as SumWinnerPrice"&B7&"to"&C7
="count(case when (td.BSP >="&B8&" and...
March 15, 2020 at 7:47 pm
declare
@txt varchar(100)='CKnovelty2002_pouch-5AR-OneSize';
--@txt ...
March 10, 2020 at 12:14 pm
I had a similar difficulty in explaining why I felt procs were preferable to EF.
By "EF" do you mean "Entity Framework" as in Microsoft? You do realize...
March 6, 2020 at 1:42 pm
"...from a developer point of view..." Why is it "more difficult" to build with stored procedures:
March 6, 2020 at 12:09 pm
It's all predicated on the false assumption "a billion flies can't be wrong"
March 3, 2020 at 12:44 pm
...how the design of a database schema (logical design of tables and queries) is affected by horizontal scaling...
Primarily through indexing. Indexes are logical objects which exist for purely physical...
February 29, 2020 at 12:51 pm
There are a lot of assumptions baked into the questions. Why are you storing shopping cart information as serialized data?
February 29, 2020 at 12:34 pm
Calling another procedure isn't returning data from the procedure.
The procedure being called might also return data. In this code test_proc1 calls test_proc2. Both procedures contain a single select statement. At...
February 28, 2020 at 5:08 pm
If a stored procedure calls another stored procedure doesn't it return data to the other procedure? The data returned would be via the input variables of the other procedure(s).
February 28, 2020 at 4:19 pm
Here's a simpler alternative to your query
select e.Clinic,ca.Area,
sum(case when ca.AreaVal = 'A' then 1 else 0 end) as A,
...
February 28, 2020 at 1:01 pm
It appears you have two different sets of information shoe-horned into the same table. Maybe the information was derived from base tables which are more straightforward to query? How is...
February 26, 2020 at 1:07 pm
Hey there... so further on down the road... I was wondering how the Calendar table was defined in this answer. Any help would be much appreciated. This thread explains the...
February 20, 2020 at 3:43 pm
In this thread:
The OP apparently was provided something that worked for SQL Server 2000. It doesn't look like it was posted tho.
February 20, 2020 at 2:13 pm
You're using 2008R2 and I don't think the daterange function I would use here goes back that far. There was a similar question asked a while back and another SSC...
February 20, 2020 at 2:03 pm
To split into days do you want to allocate evenly across all days or exclude weekends and holidays?
February 20, 2020 at 1:48 pm
Viewing 15 posts - 1,111 through 1,125 (of 1,390 total)