Topics
Started by
Posts
Last post
Hi everyone, I can post DDL and execution plans if desired, but perhaps this question can be answe…
19 replies
I have a requirement to show and count the top 5 records and then they want a count of the remaini…
10 replies
Hello, I’d like to confirm if what I am attempting is possible. I suspect it’s not, but wanted to …
1 replies
I have created a STORED PROCEDURE, which includes 5 different CURSORs. The company I am working for…
137 replies
Ok I need to create Called customers That contain a persons firstName, LastName, and social securit…
2 replies
Hi all, I have a update statement which is as A = B + C * D. i would like to know which operations…
12 replies
Recently i had seen the following in many SQL Server forums FOR XML PATH ('') I am not sure what do…
2 replies
I have stored alter commands in table for reindexing. How should I execute them one by one using cu…
2 replies
while i am writing query, select * from table name where column like '%N%' escape'\' in oracle its …
2 replies
I have 2 tables. One table contains all parent accounts, top level of hierarchy. Second table has…
20 replies
Hi Guys, I need to create a stored proc that takes an xml input parameter, which must be used in th…
1 replies
create table QA_Test (ID int,BID varchar(5),NumBldgs int) Insert into QA_Test Select 123,'001',4 Un…
10 replies
I want a merge procedure for every table in a particular schema, and I have a script to create them…
2 replies
I have a store proc with 2 major parts in a while loop. A SELECT then an UPDATE The basic store pr…
2 replies
Hi, how can I get effectively max(version) to identify any PersonID with multiple VersionID? Person…
3 replies
Viewing 15 topics - 5,371 through 5,385 (of 10,647 total)
You must be logged in to create new topics.