Topics
Started by
Posts
Last post
Hi, I am facing a situation where in the UDF takes more time when compared to the base query itsel…
2 replies
could some check whats wrong wif my insert statement?? INSERT INTO Photovoltaic (PV_site, PV_stat…
1 replies
This is one of those “simple” issues that is driving me crazy. The following is for when the user …
12 replies
Hi, I'm trying to update a single row table (Transaction_Status) with a new value. The field to upd…
6 replies
i got this message when i was executing my trigger.. the error message is Msg 1013, Level 16, State…
12 replies
Hi all, Does anyone know a workaround in T-SQL to retrieve names which has a french accent mark SEL…
1 replies
How do I name a column when using a For XML Explicit clause. I would have expected this to be simpl…
2 replies
Hello everyone, I have a SQL statement thats looks correct but I can't seem to figure out why it's …
10 replies
Hello Everyone I am trying to change the ownership of all objects of a certain type, such as all th…
3 replies
Hi all, I am having an issue selecting only rows that contain the MAX(createdate). I will break dow…
4 replies
The trigger below will send the correct e-mail twice for Yes and an empty e-mail twice for No: CREA…
5 replies
Hi, If you use ANSI joins in a select statement, are there any occasions when you would still need …
6 replies
Hello. I have the following table and sample data: Id | CacheString ----------------- 1 | 'Cache …
6 replies
Hello, Trying to get this statement working: IF NOT EXISTS('SELECT ' + @ColumnName + ' FROM ' + @T…
10 replies
Hi everyone, I have a table with the following structure and data -- Step -- Id(PK), RisktID(FK), D…
10 replies
Viewing 15 topics - 10,726 through 10,740 (of 12,234 total)
You must be logged in to create new topics.