Topics
Started by
Posts
Last post
Hi, Select LHP.LHP_PARAM_RESULT_VALUE, Cast(Replace(LHP.LHP_PARAM_RESULT_VALUE,',','') as decimal(1…
14 replies
Hi All, I have a Trigger which basically using the INSERTED and DELETED Tables - populates an "Audi…
8 replies
I have this code working fine. I need to subtract one column from another to get the corrected resu…
12 replies
Hi, I've got a really annoying problem in that I have a char column (loaded from csv) that contains…
7 replies
Hi what’s the best to way to drop out of a cursor if a condition is meet? Many thanks
4 replies
Here is how the data looks like for UserSession Table UserName LastUpdated sessionID -----…
6 replies
Hi, I have an MS Access application whose tables are linked via ODBC connection to SQL server 2005.…
14 replies
I have an sql like this: SELECT 1 AS GROUPID, 'A' AS GROUPNAME, ''GROUPID, ''GROUPNAME UNION SELECT…
3 replies
Hi, I have a column (Total) which needs to be updated based on a calculation of 2 other columns(Ass…
2 replies
First of all, I know I shouldn't do a shrink file because it causes fragmentation. however, I am w…
4 replies
Hi, I need to update the Perc column in Table_A This is based on the following calculation: ((Pass/…
7 replies
Hello - I have a column in my View script that I convert to varchar(10) and want to convert it bac…
3 replies
Hi, A stored procedure calls on this UDF. I have to update it to exclude email addresses with '.@' …
8 replies
I pass an XML parameter from a C# program. This seems to work fine if i change the encoding from ut…
1 replies
I'm running something like this: more: waitfor delay '00:00:05' insert top (1000) into TableB Selec…
11 replies
Viewing 15 topics - 676 through 690 (of 12,234 total)
You must be logged in to create new topics.
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy