Topics
Started by
Posts
Last post
Given tables- Client ClientId (IDENTITY) LastName FirstName MiddleName ClientAccount AccountId…
6 replies
Hi All example If I retrieve the item_code = 'Pr1001' This Code may be in 4 o 5 table how can we s…
4 replies
I was trying to use xquery to extract the data from a xml field so that i could use that data in an…
7 replies
Hi I want to merge multiple rows into single row with filter condition on trd_id. Will appritiate i…
2 replies
Hello all, this is my first post though I have been a memeber for a while and you guys have saved m…
10 replies
Hi, I am capturing results from "1st day of the month" to "last day of the month". How can I replac…
2 replies
Hi, Can anyone help me to convert the character to DATETIME SELECT Convert(datetime,'2009-02-26T00…
2 replies
hi all, is there any method to count number of spaces between two strings? thanks in advance.
2 replies
The following query fails reporting 'An aggregate may not appear in the set list of an update state…
3 replies
are there any simpler way to do this instead of nested loops? declare @T table (col1 int, col2 int…
4 replies
I think this will be a simple solution, but I am not seeing it yet. I have a football pool learning…
3 replies
Hi, I am attempting to do a full outer join using this query. but SQL Server neither support this …
1 replies
I have data in a column of Decimal datatype(38,20) like this, 0.00000000000000000000 10.00000000000…
19 replies
Hello, I would like to create a query from a single table with the following columns. SEQNO is a un…
38 replies
My T-SQL works but has one problem. (c.POBuyersItemKey = b.ponbr + '|' + b.BuyersItemNbrP0107) F…
5 replies
Viewing 15 topics - 6,451 through 6,465 (of 12,230 total)
You must be logged in to create new topics.