Topics
Started by
Posts
Last post
I have two apparently identical databases on the same server instance and when I use a select for x…
2 replies
Hello, I try to create the following view: CREATE VIEW TOPDESK AS SELECT cast(wnr.WNS_ID as varc…
2 replies
How can I merge the two queries to return a count of the employees and a count of the employees usi…
2 replies
Hello Am using the following query, which is giving me duplicate records, can anyone please tell m…
9 replies
Hi, Earlier I created an instead of trigger to prevent updates containing a certain string to a num…
4 replies
hi members, The following are the tables I use: declare @totable table (gid int,parent int,id int,p…
1 replies
I have inherited a T-SQL script from a developer and have found the following statement, which has …
2 replies
Hi All, Sorry if this is posted in the wrong area, I'm currently being trained up on SQL Server 20…
3 replies
Hi all, I was wondering how i can convert the following int value to datetime (ie 20090101) I have …
6 replies
Dear all, In my database date is stored like '2004-01-07 00:00:00' & is it possible …
8 replies
I have a sql script which performs well until I try to encapsulate it in a stored procedure. The st…
3 replies
Hi All, I need a query to know who deleted my Table..from my database. Cheers! Sandy. --
9 replies
This is related to an article on mssql tips: http://www.mssqltips.com/tip.asp?tip=1545 I have a num…
6 replies
hi i got a excel file which i just need to import to sql server DB so the problem here is i will be…
1 replies
hi members, The following are the tables I use: declare @totable table (gid int,parent int,id int,p…
4 replies
Viewing 15 topics - 9,181 through 9,195 (of 12,234 total)
You must be logged in to create new topics.