Topics
Started by
Posts
Last post
Hi All, I am getting below error messages when executing below update sql. UPDATE a SET club_status…
9 replies
I need to create a function for multiple stored procedures so it's easy to manage changes. It's slo…
40 replies
Hi, I have a search stored procedure that basically performs a query similar to select top 10 prim…
3 replies
Lets say I have a table as MIDTime (Hh:Mm) M110:22 M112:15 M113:22 M116:00 M117:50 I need to…
12 replies
Hi i got two tables #users and #a, where i loop through table #a and update table #users. The code …
8 replies
Hi, Hope it's the right forum! With PDW AU3, I know stored procedures are supported but some functi…
5 replies
I have table schema and data as in attached. I would like to group by each schoolyear, each schoolI…
18 replies
Hi, I am working on a GPS related issue. There is a table where we keep geographical information o…
9 replies
Could you please help me solve a query problem: For a given set of StoreGroup(s) or for all StoreGr…
13 replies
OK, I'm trying and failing (to an extent) to get my head around set-based iteration. As a sometime …
46 replies
I want to preface this question by saying that I am new to SQL and new to these forums so bear with…
22 replies
I have two tables , the schema is attached. I would like to get the result as the second attachment.
9 replies
Ok... this is just friggin wierd. We have a field called "ISDELETED". If the record is current th…
67 replies
Hi All I am having an issue grasping the behaviour of Joins. DDL: CREATE TABLE [dbo].[T1]( [Col1] …
3 replies
Hi, I have a query where the last left join is killing the performance. Someone suggested me to rep…
19 replies
Viewing 15 topics - 5,881 through 5,895 (of 10,644 total)
You must be logged in to create new topics.