Topics
Started by
Posts
Last post
I have a table like this: declare @T table (cid int, model char(4), shipdate datetime, quantity …
1 replies
A while back, i think in March, i posted a question on how to search for any word in any order and …
7 replies
HI I am running the sql below: declare @p1 int set @p1=0 declare @p3 int set @p3=1 declare @p4 int …
2 replies
I like to know what script is used to determine the space usage values for the data and log-files a…
3 replies
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
Viewing 15 topics - 6,451 through 6,465 (of 12,234 total)
You must be logged in to create new topics.