Topics
Started by
Posts
Last post
Hi, I'm trying to write a dynamic sql string where a user selects a number of values on the form to…
7 replies
Hi, I am trying to convert queries which include NOT IN clause so that they can be done using JO…
2 replies
Dear Friends, Is it possible to convert or cast a varchar datatype field to datetime. My table cont…
17 replies
Please help me to query from the following. The number of distinct rows of system needs to be count…
2 replies
SET NOCOUNT ON DECLARE @Relations TABLE ( Main VARCHAR(10), Related VARCHAR(10) ) INSERT @Rela…
9 replies
I have a dynamically builded query, for example 'select Name from SomeTable where ID = 12…
3 replies
Hi all, Please help me in solving following query. Can we define in sql server the same parame…
7 replies
i have a table with no primary key or id column. each record is duplicated anywhere from 3 to 12 ti…
2 replies
Hello I have inherited an awful piece of code that badly needs optimising. It currently is a …
5 replies
I need to be able to split a comma-delimited string in a table column and do a select in another ta…
3 replies
Hi all, I currently have a query like this: SELECT dbo.MyFunction(a) as Column1, b as Column2, (cas…
4 replies
Hi there people, I had a bit of a look around the site and couldn't find this answered anywhere, so…
4 replies
I hav this function: ALTER FUNCTION fnEmployeesByGroupCode (@GroupCode as varchar(50)) RETURNS TABL…
8 replies
aaaaa,bbbb,ccccc,dddd,ffff,gggg,llll,kkkk,nnnnn How can split the above string to the following ind…
4 replies
Can any
20 replies
Viewing 15 topics - 6,541 through 6,555 (of 17,082 total)
You must be logged in to create new topics.