Topics
Started by
Posts
Last post
Hi, i need a query to find out all orphan over a hierarchical table with the code above i can get a…
11 replies
I have a table having three column Name Value1 Value2 Value3 A 1 2 …
31 replies
I'm working in an environment where some very wide tables are present (400+ columns). Whilst long t…
5 replies
declare @colnames as varchar(max) set @colnames = ( SELECT STUFF(( SELECT ', ' + name FROM sys.co…
6 replies
I have a Table which have two columns 1. UserName 2.Password. Now I need to create stored procedure…
5 replies
I am working for a small company and have been placed in the roll of a DBA. I am a systems engineer…
3 replies
Hello all, After searching for possible solutions, I haven't found anything that provides me with w…
13 replies
Hey, does anyone know if there's some undocumented feature that would allow you to query a table by…
7 replies
Hello We have an enterprise application on Visual Basic 6.0 that is currently running with SQL Serv…
3 replies
Some one help me to convert the recursive method to iterative function. USE [db] GO /****** Object:…
8 replies
I have below kind of strings: 21-12-ABCD 23-1-hdf 19-1345-dsnf i want a result like below for each …
13 replies
Can someone help with the query? I have a table here: CREATE TABLE [dbo].[aas]( [id] [int] IDENTI…
3 replies
I have a sp that I generates records per patient. The patient could have multiple records or just …
10 replies
Dear Experts, OT sum is not computing correctly in case of multiple clock events, find below my sql…
16 replies
I have a stored procedure that updates a few 1000 records in a table. When I run the SP from within…
7 replies
Viewing 15 topics - 2,926 through 2,940 (of 3,083 total)
You must be logged in to create new topics.
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy