Topics
Started by
Posts
Last post
All I need is convert Column(A1/A2) into rows and rows(1 into Jan) into columns.Input: Here A1/…
6 replies
Hello everyone I'll get right to the point.I have the following script:create table #tempData(recid…
9 replies
Hi,I have an interesting project. I need to show materials that make up parts then find mater…
3 replies
Hi All, Help required in re-writing below WHERE predicate so that an index on date column can be ut…
19 replies
--===== If the test table already exists, drop it IF OBJECT_ID('TempDB..#mytable','U') IS NO…
3 replies
Hello Experts. Ive been trying to find the whole weekend a logic which is creating a xml file of th…
7 replies
Under what circumstances will a stored procedure be recompiled in SQL2012? Specifically, will…
2 replies
Create table #temp ( UserName Varchar(100), Report_Date Date, Time_MS BIGINT, TIME_COLUMN TIM…
11 replies
Greeting, I have the following expression that is return #Error when the data contains a …
3 replies
I have a table that have different grains - in most cases it's weekly, except in some cases for som…
4 replies
I need help to Query optimization. Query is part of StoredProcedure which executes for more than on…
2 replies
Create table #Main ( ID INT, Group_Num Varchar(100) ) INSERT INTO #Main(ID) values(1),(2),(3),…
5 replies
Hi,I need a help in writing a query.data looks like ID TAB …
6 replies
Hi, I need to have a calculated field called EndDate and it should exclude weekends from the caluca…
4 replies
Hello, I'm still new to SQL and i'm stuck. I have a case when statement but the results aren't comi…
5 replies
Viewing 15 topics - 1,036 through 1,050 (of 4,984 total)
You must be logged in to create new topics.