Topics
Started by
Posts
Last post
I have the below query: SELECT top 1 listing as listing ,ISNULL(category,'…
8 replies
Hi all: I am having trouble with some decimal division inside of UDF. For example, I want to get de…
2 replies
Have a table1 with following records Server name --------- …
4 replies
I'm trying to create a recursive cte that can select manager - employee next level down - employee …
9 replies
Hi Sample Data: CREATE TABLE #test (key_value INT, test_value INT); INSERT #test SELECT 1, 2 UNION …
6 replies
Hi All, i have 9 columns say qso,cp,cd,qsoYESpercentage,cpYESpercentage,cdYESpercentage,qsoNOpercen…
2 replies
I see lots of examples where one needs to parse a csv list to find the gaps of missing values or a …
4 replies
Hello, I have a table: AccountNo, Period, Amount 100, 11/02, 100 100, 11/03, 110 100, 11/04, 120 11…
2 replies
I was setting up to do a demo on how to eliminate duplicate records from a heap and, after reading …
6 replies
I have Table of ClientMaster and 4 Tables of Purchase, Sale, Receive, Transfer. ClientID is passing…
3 replies
Hi I am having a strange issue selecting data from an indexed view... I have created an indexed vie…
6 replies
HI All, i want to retrieve the records from the sql server database table where the condition is o…
7 replies
This is an SQL that gets SALES information. But I am having difficulty getting SALES information fo…
26 replies
I am fairly new dealing with XML but I know there are special characters that XML does not like. So…
16 replies
I was wondering about how a JOIN works for 3 or more table. I understand that a LEFT JOIN will get …
10 replies
Viewing 15 topics - 8,281 through 8,295 (of 10,635 total)
You must be logged in to create new topics.