Topics
Started by
Posts
Last post
Please assist. I have this query: App Filter Categories select a.label as 'App Category' , b.lab…
1 replies
I'm rewritting some data warehouse load procs. The current process is filled with isnull(name,'n/a…
4 replies
Dear ALL I have a requirement of converting different date ranges into one single row, group by Emp…
10 replies
Doesn't seem right to me however i'm not as familiar w/ column store indexes
2 replies
The kind users of this forum have helped me develop a stored procedure that imports CSV files in a …
3 replies
Please assist? Need to write a query that returns the names of all the professors and their respect…
4 replies
Looking over a few data warehouse procs internally that we created by contracting firm. Noticed tha…
22 replies
I have a big ColumnStore table partitioned on a DATE column (billions of rows) That table is struct…
7 replies
I am having an error with this code: select customer_name, order_id, (case when sum(stat…
1 replies
Hi all, This code gives 2 results SELECT distinct(AtcCode) as id, Atc_Text FROM [dbo].[Drugs_Basi…
1 replies
On what basis should i compare performance of queries? Query 1: select * from dbo.Table1 where [T…
6 replies
I have a DB full of RACES and RUNNERS, COURSES, STATS etc etc. One horse could appear in the table …
14 replies
I have a stored proc that isn't horrible, it runs in a few seconds, it just has high executions and…
33 replies
Hi Sir, I have some data, and I want to update the enddate columns data from table abc which has pr…
2 replies
Hi All, After a long time posting my query. It would be great help if anyone can assist on this. I …
4 replies
Viewing 15 topics - 196 through 210 (of 1,532 total)
You must be logged in to create new topics.