Viewing 15 topics - 30,961 through 30,975 (of 284,012 total)
Topics
Started by
Posts
Last post
Hi Experts, Can this below sql statement be optimized? There are some 40 lakh odd recor…
4 replies
Hi there, So my query is something like that Select U.actionID, M.CardNum, M.serieID... From Upgrad…
5 replies
Hello , i am writing simple query to create and insert values into table variable, table is being c…
6 replies
Hi, I am not sure if this post is meant to be in this thread so apologies in advance. I…
2 replies
I have already the solution for the problem, but not so sure if it was the proper way to do it. I h…
1 replies
Create table #temp ( UserName Varchar(100), Report_Date Date, Time_MS BIGINT, TIME_COLUMN TIM…
11 replies
I've worked a little bit with a few production SQL databases and all of them to a fault were a MS S…
2 replies
I am trying to add an interactive sort to a table using an expression that returns a percentage how…
2 replies
Comments posted to this topic are about the item Shape the matrix
4 replies
Hi All, I have been presented with a task to write a FIFO allocation Recursive CTE (or any other so…
19 replies
I currently have a large query which is taking over an hour to run, and am attempting to optimize. …
10 replies
Hi I have a filed in one of the tables and Following is the sample data in this column.Field ID Fie…
3 replies
Hi, tried to create below indexCREATE NONCLUSTERED INDEX IDX_POSITION_ID_FROM_DATE_TO_DATEON [CR].[…
17 replies
Hello All, Can someone please advise if there is a way to stop SSMS providing the server name autom…
9 replies
While trying to convert a varchar field to a date I am getting the error "conversion of a var…
4 replies
Viewing 15 topics - 30,961 through 30,975 (of 284,012 total)