Topics
Started by
Posts
Last post
Hello everybody, how would I achieve that values in two columns are randomly exchanged? E.g. there …
3 replies
I am new to the world of xml and sql 2005. I have a xml file which contains both elements and attri…
1 replies
I have an year column which displays year as YY format. I want to display them in yy-yy format. E.…
8 replies
Hello Comunity I have the following script : SELECT (case when lp.u_pagpagar=0 and lp.u_pagchpd=0 …
3 replies
I have an imported record set where the name is just one field in a table. I need to split it out …
5 replies
I am planning to move the huge database to its own disk with 3 different luns for ldf, mdf, and ind…
6 replies
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Text;Database=C:\TEST\;HDR=NO', 'SELECT * FROM…
1 replies
Found this function on Experts-Exchange and was wondering how to modify it to work for social secur…
4 replies
Hi all, Im having a really hard time with this query. I didnt even know what to call it so sorry ab…
23 replies
Hello, While running a query,I get warning message saying "Warning: Null value is eliminated by an …
4 replies
Hello all, First of all i need to tell every 1 i am new at this. I have this view that runs fine in…
5 replies
Hi declare @dFrom varchar(12) set @dFrom = convert(varchar,getdate(),112) INSERT INTO OPENROWSET (…
1 replies
The two queries are returning two different no of rows.Outer join is not supposed to duplicate the …
7 replies
I have a stored procedure where you can pass either @tableId, or @ParentId. In this case the progr…
1 replies
Hello I am trying to apply MIN function on computed Column. Wondering how can I do it. Code example…
1 replies
Viewing 15 topics - 8,551 through 8,565 (of 12,230 total)
You must be logged in to create new topics.